how do u make a foreign key

[Guest]

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

 

[John Vinson]

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]