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 (1) |
Please zip all files prior to uploading to Files section.
Tidak ada komentar:
Posting Komentar