finding the bug record(s)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two large tables of data that I want to link with Rererential
Integrity enforced. Access wont let me do that. I need an easy way of
finding the bug record(s) in the table on the many side of the 1-to-many of
the relationship.

Any ideas on how to do that?

John
 
I have two large tables of data that I want to link with Rererential
Integrity enforced. Access wont let me do that. I need an easy way of
finding the bug record(s) in the table on the many side of the 1-to-many of
the relationship.

Any ideas on how to do that?
Click to expand...

The Unmatched Query wizard will help; or you can roll your own:

SELECT tblMany.ID, tblMany.This, tblMany.That
FROM tblMany LEFT JOIN tblOne
ON tblMany.ID = tblOne.ID
WHERE tblOneID IS NULL;


John W. Vinson[MVP]
 
Back
Top