Error creating new primary key

[quicksun]

Hi,
I want to delete the primary key that is created when the database was first made and create another primary key from another column. I have followed the instructions in the help file and it looked to me that I had created the primary key that I wanted, but when I tried saving the file I got the following message: "... created duplicated values in the index, primary key, or relationship." I am using Access 2007. I tried looking for the error but can't find it. Does anyone have an idea where I might find where the error is?
Thanks,
quicksun

[June7]

There must be a duplicate value in the other field and the new pk field is set for No Duplicates.

Do a query that groups on the other field and counts the records. This should reveal the duplicated values.

[quicksun]

There must be a duplicate value in the other field and the new pk field is set for No Duplicates.

Do a query that groups on the other field and counts the records. This should reveal the duplicated values.

Thanks for the information. I'll do that search.
quicksun