Re: Access as a RDBMS--why the multiple relationships?

From: raylopez99 <>
Date: Sat, 15 Dec 2007 07:17:13 -0800 (PST)
Message-ID: <>

On Dec 15, 5:40 am, "David Cressey" <> wrote:

> When Ray mentions the "Relationship Window", he's talking about a specific
> tool that Access
> offers the designer. The tool basically allows foreign key references to be
> catalogued for later use by Access. Foreign key references can have
> enforced referential integrity but this is not mandatory. There is a check
> box.
> So what are foreign key references used for when referential integrity is
> not enforced?
> They are used by MS Access for figuring out the "on" conditions for INNER
> JOINS. The typical MS Access user doesn't even speak SQL, never mind
> relational speak. The graphical interface takes care of all of that.

Yes, you're right Dave. THat's what it is, and now I see it's OK to have two such arrows, no big deal.

RL Received on Sat Dec 15 2007 - 16:17:13 CET

Original text of this message