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
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar