how do u make a foreign key

microsoft.public.access.gettingstarted

26 Feb 2005 1:23 AM

D L Barnard

i understand what a foreign key is. i have forgotten how to assign one. pls
advise. thank u to whomever respnds. (university student).

26 Feb 2005 2:52 AM

John Vinson

On Fri, 25 Feb 2005 17:23:05 -0800, "D L Barnard"
<DLBarn***@discussions.microsoft.com> wrote:

>i understand what a foreign key is. i have forgotten how to assign one. pls
>advise. thank u to whomever respnds. (university student).

Simply use the Relationships Window and create a relationship from the
Primary Key of the "one" side table to the appropriate field of the
same datatype (Long Integer if the primary key is an autonumber).

There is nothing special in table design view to indicate that a field
is being used as a foreign key; it's not a property of the table or of
the field, so much as how the field is being used.

John W. Vinson[MVP]