Link to home
Start Free TrialLog in
Avatar of JohnE
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
Avatar of JimBob091197
JimBob091197

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
Avatar of ZifNab
ZifNab

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Paradox, Oracle and Informix support Cascade Deleting.
Also you can use Table1.BeforeDelete event.