What is a Primary Key?

A primary key is a system used for indexing, and is usually a number that is automatically assigned by Access to each new record. These can also be used as ID numbers for each record. There can only be one primary key per data source. The value of the primary key field will be unique for each record and can be used to distinguish records with the same information.