Hi Mike,

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.

>>I have a situation where I need to delete records that may have many related records.
>
>Add this tables to a DBC id not already, then set up a relationship if they aren't already related. Then, go to the Database menu while modifing the DBC, and choose Edit Referential Integrity.
>
>This will automatically (depending on what you choose) ignore, restrict or cascade deletes if you delete a parent record.