Creating a query to discover values violating referential integrity

I'm doing some data warehousing for this charity and I can't enforce
referential integrity. I know there is a value out there that violates
it and I was wondering if anybody knows a way to design a query which
will give me the values that violate RI. I'm using Access 97 and I
would appreciate your help! Thanks.

Create a new query.
The first dialog offers the "Unmatched Query Wizard."
Use that to identify the records in the import table that don't match the
records in the lookup table.
>
There's another wizard there to help you track down duplicates, or use this:
http://allenbrowne.com/xbase-04.html
>
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
>
"mmoski" <mmoski@gmail.comwrote in message
news:1165993771.403510.309200@j44g2000cwa.googlegr oups.com...