Delete records in one table based on list in another table

[clmarks]

I'm currently running Access 2003. My database contains master client records, each of which has as many as three types of child records. My database is set up so that the child records will be deleted if the master is deleted.

I have made a query writes out a table containing the ClientID field for any clients who have not received services in at least three years. I want to delete the master records for these inactive clients.

Will Access delete the appropriate records in the master table based upon finding a matching ClientID number in a second table? If so, how do I do it? If my approach is way off base, please point me in the right direction.

Thanks for any help offered.

cm

 

[clmarks]

For anyone who is interested, I ended up updating a blank field in my master records to "xx" if there was a match in my list of obsolete records. I then used a delete query to get rid of all of the master records that had the "xx" in that field. It was fast and easy.

c