Referential Integrity

[Gerilee]

I'm new at Access and trying to set up a relationship between two tables using referential integrity. The two tables are related by the column stockno where the 2nd table should not have any stockno that is not in the 1st table. The data was loaded from a UNIX box where this wasn't enforced, but I cleaned up the data before I imported it. It imported clean but when I try and enforce referential integrity between the relationship of stockno in both tables, I get an error message telling me that I have stockno's in table 2 that don't exist in table 1. I am trying to write a query to find which ones exist in table 2 that don't exist in table 1 but am having a lot of trouble with that. I changed the join properties to #3 but this just gives me all of the ones that do exist. I need the ones that don't. Thanks for any help.

 

[jebry]

Hi!

The easiest thing to do is to use the find unmatched query wizard in the new query menu.

hth


Jeff Bridgham
bridgham@purdue.edu

 

[Gerilee]

jebry,

Thanks so much! Worked great and problem fixed.