Primary+ Foreign Keys

[PL]

Hi

Using Access 2003.

As a beginner,
I am confused about the above. And how do I insert Foreign Key?

Thank you

 

[Mr B]

PL,

It would help if you could provide a little more detail about exactly what
you are trying to do and in what context you are trying to do what you are
doing.

With a little more info it will be easier for us to try to assist you.

Mr B
askdoctoraccess dot com

 

[BruceM]

One possible short answer is that a foreign key exists only because of its
relationship to a primary key. Unlike a primary key, you do not designate a
foreign key when you design the table.

 

[Stefan Hoffmann]

hi,

Using Access 2003.
As a beginner,
I am confused about the above. And how do I insert Foreign Key?

A foreign key is defined within the relationship window. You simply drag
the primary key field(s) from the table on the 1-side of your relation
to the according field(s) to the table on the m-side of your relation.


mfG
--> stefan <--