delete query not working

[lyndah]

I have a customer database (table A) that I want to delete a large number of records from. The details of the records I want to delete are in another table (table B). I've created a select query to select the records from table A that are also in table B. The select works fine - but I can't get a delete query based on that to run. Any help appreciated

 

[SkipVought]

Hi,

Try running the Delete on table B first and then table A.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[dhookom]

Assuming these are parent/child, if you had referential integrity on with cascade deletes, you would only need to delete from the parent table.

Duane
Hook'D on Access
MS Access MVP