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

From: raylopez99 <raylopez99_at_yahoo.com>
Date: Sat, 15 Dec 2007 07:17:13 -0800 (PST)
Message-ID: <a06c370c-82b8-4329-8313-d91febf3c03f@q77g2000hsh.googlegroups.com>

On Dec 15, 5:40 am, "David Cressey" <cresse..._at_verizon.net> 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 - 09:17:13 CST