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
 
Select "edit" when prompted, then add the second link in
the linking window.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top