Delete query

[Treason]

I have two tables... One with Employee data, names, ID#'s and bio data. The second table has Id#'s and job information... for example

Table1
EmpName EmpID
Rivera 0003
Smith 0004

Table2
EmpID JobNum
0003 12345
0003 12346
0004 54312
0004 23143

I maintable Table2, but Table1 I import from a txt file at the start of each day. ok so here's my question...

I need a delete query that will erase all records from Table2 if the EmpID no longer exists in Table1.

This sounds easy enough but every time i try it, the delete query shows in datasheet view, but when i run it it gives an error or it doesnt delete. Any Ideas?

 

[GumbyD]

Set the Unique records properties value to Yes on your delete query.

GumbyD