Linking two primary keys table to table

  • Thread starter Thread starter SteveAlb
  • Start date Start date
S

SteveAlb

I can establish first primary key link table A to table B.
When I try the
second different primary key link, table A to table B, a
message appears that
link between tables exist and if new link is needed or
edit existing link.
When I proceed to establish new link a table with the same
name appears but with a 1 to denote different name.
I have done this before. I am using ACCESS 2K.

TIA
SteveAlb
 
This is called a combined primary key. when setting up the primary key in table A select the key field(s) and apply primary key
 
Try to select both fields at once and set primary key. Do this as well for
table B and then link 'm.
Marmite said:
This is called a combined primary key. when setting up the primary key in
table A select the key field(s) and apply primary key.
 
Back
Top