Relational delete

[lipszydz]

I've got 3 tables , which were previously just 2 tables in relation n:n ,
then I've devided them into 3 tables, with double relation 1:n to the main
table.
There comes the task to delete the record from the main table, but when it's
done, I've got some trash in the 2 existing tables (which should be also
deleted).
Is there any way to delete the records which are in relation with the main
record without using macro's?

Przemek Lipka

 

[Scott McDaniel]

If you setup realtionships via the Relationship window (it's on the main
toolbar when viewing the Tables in the database window), you can also set
them to Cascade Delete\Update ... this would delete all child records when
deleting parent records ...