Access

Hi,

I am having the hardest time setting up a table with an index that will allow duplicates in that column. It keeps telling me to "redefine index to permit duplicate"--which I have not clue how to do that.

I have Access 2002 and this is how I changed the primary key to allow duplicates.

Just open the database with Access, right-click whatever table > design view, then go to the indexed field and click in it.

right-click your field (there should be a little key icon beside it) and click primary key to get rid of it. You can't edit it while its a primary key.

Now, just reassign it the key as an index BUT one that allows duplicates, to do so to the following::
in the bottom field properties there's two tabs, "general" and "lookup".

Make sure its on the general tab and at the VERY bottom they'll be an 'indexed' label, beside that is a drop down column with:
No
Yes (Duplicates OK)
Yes (No Duplicates)

Select the Duplicates OK one and you should be golden.