By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,154 Members | 2,405 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,154 IT Pros & Developers. It's quick & easy.

Creating a query to discover values violating referential integrity

P: n/a
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.

Dec 13 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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" <mm****@gmail.comwrote in message
news:11**********************@j44g2000cwa.googlegr oups.com...
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.

Dec 13 '06 #2

P: n/a
Wow, thanks man, I didn't think the answer would come so quick.

Allen Browne wrote:
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" <mm****@gmail.comwrote in message
news:11**********************@j44g2000cwa.googlegr oups.com...
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.
Dec 13 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.