Delete query

C

cottage6

I want to create a delete query that deletes records from both tables in a
one-to-many join. Both tables have corresponding social security numbers,
but the deletion criteria is Termination Date Is Not Null with the
Termination Date field in the primary database only. This is probably easy
but I've tried a couple things that haven't worked. Can you help? TIA!
 
C

cottage6

Thanks, looks like unique records did the trick! Also thanks for the quick
response.
 
Top