Simple Query - Find junk records

[iddqd]

Well, I'm trying to enforce referential integrity on one of my relationships. But it seems that there are 5 records in the Subtable that don't have a corresponding record in Table, so it won't work. I tried copy/pasting from Subtable to Table, and it says 'unable to make changes because this would make duplicates in the primary key' to all values except 5. Which it asks me if I want them pasted. If I click 'yes' or 'no' nothing happens either way.

Well, anyway, I need code for a query that selects all records from Subtable.Field1 that don't exist in Table.Field1.

 

[ColinEssex]

use the "find unmatched query" in the query wizard

Col

 

[iddqd]

use the "find unmatched query" in the query wizard

Col

I... don't see that option in the wizard.

Edit: Well, I found another solution to the problem - creating an empty copy of the tables, and setting up the relationship, then copy/pasting the records in and seeing which ones will return errors.