JohnE
asked on
Deleting Records in Master/Slave Tables
I have a database application that has one master table with 3 slaves. They are linked together by the common field of title. How can I delete a record from the master table and have the corresponding titles deleted from the other tables?
Thanks
JE
Thanks
JE
Which database are you using? Some databases do support this kind of referential integrity, and will delete the records for you if you set it up to do so.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Paradox, Oracle and Informix support Cascade Deleting.
Also you can use Table1.BeforeDelete event.
Also you can use Table1.BeforeDelete event.