>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.
I guess, your only option (if you really want to autonmate it) is to write your own UPDATE trigger which may search through the child tables, recalling some records there. This way you probably will flag this trigger procedure to prevent unwanted 'recall' cascading.
Edward Pikman
Independent Consultant