Purpose for unique indexes
Posted on 2011-09-02
I am seeking affirmation or clarification on indexes that serve to maintain data integrity and setting a primary key as AutoNumber.
As I understand indexes I can create an index that references up to six other fields making each field unique. This index is not a primary key but serves to maintain data integrity. The purpose for the primary key serves as a link in other tables. In other tables this would be known as a foreign key.