Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 277
  • Last Modified:

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
0
JohnE
Asked:
JohnE
1 Solution
 
JimBob091197Commented:
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.
0
 
ZifNabCommented:
Have a look at the borland technical support pages for this :
http://www.borland.com/devsupport/delphi/ti_list/TI2837.html
0
 
ronit051397Commented:
Paradox, Oracle and Informix support Cascade Deleting.
Also you can use Table1.BeforeDelete event.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now