How do I find the bad records ... to Enforce Referential Integrity

Z

ZBC

I have two tables (previously created by someone else.
Both tables have a field call RecNO that should be common to both tables
on a one to many relationship.
Apparently there are RecNO entries in the 'many' that are not in the
'one' ... HOW DO I FIND THEM?
There are over 12,000 to look through and compare ... can I use a query?
 
A

Allen Browne

Yes, you can use a query.

When you create a new query, one of the choices is the Unmatched Query
wizard. It will do the job for you.

Essentially it's an outer join between the two queries, where the one size
is Null.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Enforce Referential Integrity not available. 6
Enforcing referential integrity across databases 4
Access not enforcing referential integrity!!! 12
referential integrity and lookup 2
Referential Integrity Q 3
Enforce Referential Integrity 1
Referential integrity problem 2
Parent Tables and Referential Integrity 3

Top