how do u make a foreign key

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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]
 
Back
Top