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