foreign key to multiple primary keys

[CharChabil]

Hey guys
Using Sql/express

Table 1 :
I set 3 fields to be primary keys for Table1 (i have just marked each field with a key (primary key)(is there anything else to do)?

Table 2 :
I should add a foreign key for this table linked to the 3 primary keys of table1

Can this be done /how? Any hint for that?
thx



Regards
Ramy

[willakawill]

Hey guys
Using Sql/express

Table 1 :
I set 3 fields to be primary keys for Table1 (i have just marked each field with a key (primary key)(is there anything else to do)?

Table 2 :
I should add a foreign key for this table linked to the 3 primary keys of table1

Can this be done /how? Any hint for that?
thx



Regards
Ramy

Hi Ramy
When multiple fields are used as a primary key, they are called a composite key. You can only have one primary key in a table. It is probably better for you to use a surrogate key. Give the first table an auto num field and make it your PK then create a foreign field in table 2 that links to the PK in table 1