Delete queries-cascade (Access 1001)

Topic

New Reply

I was playing around with delete queries where the referential integrity was engaged and cascade delete was activated. All the books I have read states you put both the one and many side tables on the QBE. When I do that the query does not work. If I have only the one side on it works properly deleting from both tables. What is the proper way of doing a delete query with cascade delete engaged? Thanks Fay

Reply | Quote

Replies

If you have a cascading delete set up, you only need the one side of the relationship. The related records will be deleted from the many side no matter what. If the tables are related but you don’t have cascading deletes turned on, *then* you need both tables in the query.

Reply | Quote