How do I delete records in a one to many relationship?

[donnew]

Good Morning! Have 2 tables; table#1 contains a field with a unique strings (numbers) and the table#2 has the same field but with many instances of the various unique strings. What I need to do is delete all instances of the strings in table#2 that match those unique strings in table#1. Have tried delete query but have not been successful - any help is greatly appreciated.

Don

 

[Shirley]

When you created the relationship did you check cascading delete. With Cascading delete if you delete a record from the one side, it will delete all records on the many side that have that record unique ID. Try this and let me know if you need more help.

 

[cmmrfrds]

Use an IN list, which can be a subquery with the list of ID's you want to delete.

delete from table#2
where theID IN (select theID from table#1)

 

[donnew]

Thanks to all that helped, we were successful. I learned a lot on this problem and can now move forward. Thanks again!

Don