Add both tables to a query. Connect the primary key to the foreign key like normal. Once you have created the connection, click the connection line and change the connection to an outer join where the e-mail table returns all records and the address table only returns matching records. Then do a query with the e-mail ID, the e-mail address and the foreign key field you joined to in the address table. In the criteria for the foreign key field from the address table put the criteria IS NULL.
Good Luck
From: AccessDevelopers@yahoogroups.com [mailto:AccessDevelopers@yahoogroups.com] On Behalf Of Jay Beckham
Sent: Friday, October 26, 2012 10:26 PM
To: AccessDevelopers@yahoogroups.com; MS_Access_Professionals@yahoogroups.com
Subject: [AccessDevelopers] Relational Integrity
I have a table of profiles. I also have a table of email address. This table has a foreign key relating it to the primary profile table. Both table have Keys.
But when I try to create and enforce relational integrity I get an error message which indicates that some of the items in the email address table do not have matching records in the primary table.
The question is what type of report or query can I design to find the missing records in the primary table?
These tables came from an Interbase database and apparently one of more of the primary records were deleted before I tried to create the relationships. I know there is a method of doing this and years ago I have done it. But just can't recall what I did. Sort of think it was a query???
Thanks
Jay Beckham
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Please zip all files prior to uploading to Files section.
Tidak ada komentar:
Posting Komentar