Hi,
Access 2003
I have two different tables which contain assets with the same primary key ('Serial Number') and these fields are linked via a one-to-one relationship (No Ref Integrity).
I am trying to figure out if their is a way to query one of these tables for records that don't have a...