Access

Hello Jane

Thank you for your question and welcome to the forum.

A primary key is a field in a table which makes it possible to make each record unique, e.g. an employee ID number, a product code.

When tables in a database are linked to each other (i.e. relationships between tables are created) the primary key of one table becomes a foreign key of the other table.

Amanda