>What's the table update error, Lar?
>
>>I have...
>>2 simple related tables
>>Using views on both to update.
>>Referential integrity on the parent table has deletions cascading to the child
>>SQL send updates to both with delete and insert
>>Primary keys on both tables = keyfield for not dele()
>>
>>The child table updates fine.
>>
>>Any parent table update results in error. The only thing that I have been able to guess is that the parent table's delete may be trying to cascade to the the child.
>>
>>Is there a way that I can have the parent use the delete and insert update? I want to be able to see the previous entries.
>>
>>TIA
Index uniqueness violated. I checked all fields and the values are in fact unique. Other info..the two tables are related thru another field called orderid...just thought that I might need another index on that one "for not dele()"...stay tuned...//:^)