Using a delete query ... Specify table...

[Guest]

Help...

I am gettting the error msg "Specify the table containing the records you
want to delete"

I have two tables. One table (Tbl1) containing a hand full of records to be
deleted from the other table (Tbl2) if they match.

I have the join going from Tbl1 to Tbl2. I have tried dropping the * from
Tbl2 down and I get the error. I have tried just dropping down all the
fields and I get the error. I have dropped down both * and all the fields -
just to see - and I get the error. I have changed the join to where equal
and I get the error. When I view the results in Design view I get the few
records I am expecting to see deleted. But when I actually run the query
each configured way so far I'm getting the error.

Please help.

 

[Guest]

I figured it out - the 'Unique Records' property needs to be set to 'YES'
when using more than one table while expecting only matching records to be
deleted.

Thanks for all your past assistance.