In the design view of the table there is section for it at the bottom
(in the area where you set formats, validation rules, etc).
The options are:
No - This field will not be indexed.
Yes (Duplicates Ok) - This will be the option used the most
frequently. It will allow the column to have non unique values.
Yes (No Duplicates) - Used for the primary key (and I am sure some
other randomfields). Each record must have a unique value in this
field.
In the design view of the table there is section for it at the bottom
(in the area where you set formats, validation rules, etc).
The options are:
No - This field will not be indexed.
Yes (Duplicates Ok) - This will be the option used the most
frequently. It will allow the column to have non unique values.
Yes (No Duplicates) - Used for the primary key (and I am sure some
other randomfields). Each record must have a unique value in this
field.
Does this apply to the following advise?
Use the Indexes tool; type a distinctive name in the left column
(UniqueCategory say). Select the Account field in the right column
next to the
name, and the Category field in the next row down:
UniqueCategory Account
Category
Check the Unique Values checkbox and save the index, and you'll only
be able
to insert one record for each account-category pair.
Open the table in design view. It's the 13th tool in the standard table design
toolbar - looks like a stack of horizontal rows getting hit by a lightning
bolt.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
