Primary Key - Yes (Duplicates OK)

I looked at the Northwind database and it has a Primary Key that has the
Indexed property set to Yes (Duplicates OK). How can I allow that on my
database. Everytime I want to change the primary key property to Yes
(Duplicates OK), it gives me an error.

Hi Ben,

You can't have a Primary Key with duplicates, it goes against the point of a
primary key, You'll almost certainly find that the duplicate index is on a
compound primary key, whereby 2 fields combined are unique, but either one
independantly can be duplicated.

nope this helps,

TonyT..


"Ben" wrote:

I looked at the Northwind database and it has a Primary Key that has the
Indexed property set to Yes (Duplicates OK). How can I allow that on my
database. Everytime I want to change the primary key property to Yes
(Duplicates OK), it gives me an error.