General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I have a parent table, with a child table. If I delete a record from the parent table, I've got the RI set to cascade the delete to the child table, which it does. However, I've got some code set up, so that if the user tries to add a new record to the parent, with the same serial #(the serial # is the key field in both child and table, BTW), that it will just RECALL the deleted record. It does this for the Parent table, but it does NOT cascade the recall to the child. What should I be doing here?
As far as my RI, it's set up this way...Update>cascade, Delete>cascade,Insert>restrict.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only