Deleting record and related records

[TedT]

I have a database where I have records related to other records, using a unique ID in the main table and duplicate ID's in the second. There are times I want to delete the main record, and need to delete all the related records in the subform (table).



How do I do this?

Thanks
TedT, California

[boblarson]

If you have relationships set and have the Referential Integrity checkbox checked and check the CASCADE DELETES checkbox, whenever you delete a parent record, any child records will also be deleted.

[ajetrumpet]

furthermore, if you want that as an OPTION, you probably have 2 options:

1) turn relationships 'ON AND OFF' with code when needed (can be found on Allen Browne's website)

2) query all the dependent records out in code when you need them and run a delete query on them.