ACCESS FEED: Re: [MS_AccessPros] Relational Integrity

Jumat, 26 Oktober 2012

Re: [MS_AccessPros] Relational Integrity

Hi Jay,

you can use the Unmatched Query Wizard to write it for you

SQL is what the query saves -- along with the layout. If you want to learn more about SQL, which is not hard, read the SQL chapter in this free book:

Access Basics
http://www.AccessMVP.com/strive4peace

Warm Regards,
Crystal

*
(: have an awesome day :)
*

________________________________
From: Jay Beckham <jay@thebeckhams.us>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, October 26, 2012 8:58 PM
Subject: RE: [MS_AccessPros] Relational Integrity

Hi Crystal

Just write that as a SQL statement without using the query wizard?

Thanks

Jay Beckham

From: Crystal

Hi Jay,

SELECT Table1.*
FROM Table1 LEFT JOIN Table2
ON Table1.ID = Table2.ID
WHERE Table2.ID Is Null;

LEFT JOIN means to show all records from the table on the left, Table1
the criteria finds where Table2 doesn't have anything to match

Warm Regards,
Crystal

Learn Access on YouTube
http://www.youtube.com/LearnAccessByCrystal

*
(: have an awesome day :)
*

________________________________
From: Jay Beckham <jay@thebeckhams.us <mailto:jay%40thebeckhams.us> >
To: AccessDevelopers@yahoogroups.com
<mailto:AccessDevelopers%40yahoogroups.com> ;
MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
Sent: Friday, October 26, 2012 8:26 PM
Subject: [MS_AccessPros] 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

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]