finding the bug record(s)

[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

 

[Douglas J Steele]

Use the Find Unmatched Query Wizard.

 

[John Vinson]

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?

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]