Delete Query Help

[cbende2]

Hello all,

The breakdown: I have two tables, Table1, and Table2. Table2 is linked to Table1 by a one to many relationship, meaning Table2 has a foreign key(multiple Table2 records for one Table1 record).

In Table1 I have a Yes/No field named [Completed].

I have a delete query that runs through Table 1 and deletes records that have [Completed] checked as "Yes."

The problem:
I'm trying to make another delete query that runs on Table2, and deletes the records that are linked to Table1 that has the field [Completed] checked "Yes"

Any help would be great!



Thanks

[June7]

Try setting Enforce Relational Integrity and Cascade Delete in Relationships builder. See if the related records in Table2 automatically delete when records in Table1 are deleted with the action SQL.

Otherwise, delete the records in Table2 first. The query will have to join the two tables so the Completed field will be available as filter criteria.

Why delete records?

[cbende2]

Thanks June7, the Cascade Delete did the trick.