To help ensure that each record in your table is unique, Access encourages you to create a unique ID field and to use this field as the table's primary key. The primary key helps with sorting, indexing, and other database functions. In your database, you should set up an ID-type field and then set this field as the primary key. This ID field might contain unique product numbers, Social Security numbers, or even an arbitrary AutoNumber field. |