Foreign Key

Dear Liz

Thank you for attending Access Introduction course. I hope you enjoyed the course and benefited from it.

It is best to design your tables along with their fields on a piece of paper.

Please find attached word doc for reference. You don't copy primary keys from one table to another and assign it as a foreign key.

First of all you have to analyse the type of relationship the two tables should have. In the example on the uploaded file you can see that ONE Dept. can have MANY Employees. BUT ONE employee can only be in ONE dept. at one time. so, therefore they will have a One - to - Many relationship.

There will be a a foreign key in the Employees table which will help to link the two tables. That foreign key will be the Dept. Code in the Employees table.

I beleive you are enrolled for Access Intermediate on 7 Oct and you will be covering this more in details in addition to other types of relationships.

I hope this answers your query. Please mark this post as resolved if you are satisfied with the answer.

Many thanks


Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007