|
|
Why is a primary key different from an index? A primary key is a special kind of index. It must be unique for every record, and it cannot have any null values. By default, table records sort according to their primary index. Access requires a primary key to join a table in a one-to-many relationship.
|