Primary key foreign key

[mclueless]

How to establish primary key foreign key relationship between tables in access???

[MMcCarthy]

How to establish primary key foreign key relationship between tables in access???

Have a look at this tutorial.

Database Normalization and Table structures

[mshmyob]

if you already have the PK and FK then look for the 'Relationship' icon (it is the one that has 3 little tables connected with lines) baring that it is under Database Tools.

Then left mouse your PK and drag and drop it over to your FK in the other table. This will setup the relationship. You will then have other options to enforce referential entegrity.

And also read the tutorial as Msquared suggested.

How to establish primary key foreign key relationship between tables in access???