indexes

[jhahes]

I am a beginner and can someone please help me with creating indexes( I think this is what I want to do)

I have a table for entering realtors

the primary key is realtorID (AutoNumber)

is there anyway to find if the realtor has been entered twice or prevent the realtor from being entered twice



thanks

Josh

 

[Pat Hartman]

What are you going to use to uniquely identify the realtor. The autonumber will identify a unique row in a table but it cannot enforce the business rule that a realtor should only exist once in the database.

In addition to the primary key which you should leave as an autonumber, your table needs a unique index. The index will most likely need to be made up of several fields. To make a multi-field unique index,
open the indexes dialog
on the first completely blank line, enter a name for the index and choose the first column. Set the property to be unique.
On the next row, skip over to the field name and enter the second field name, do the same for the third, etc - up to 10 columns.
By leaving the index name blank, you are telling Access that the fields in the list all belong to the same index.