>>Thanks for the reply. If I do that will I need to do a TABLEUPDATE() after the deletion of the parent record on each child tables and or the parent table? All the tables are in the DBC.
>
>To commit the changes you would. But I would guess that as soon as you delete a record, the RI would take effect, and if it were on buffered tables, it RI would only effect the buffer. I don't know for sure though, someone else will probably jump in.
Triggers don't act until the record is committed.
Erik Moore
Clientelligence