G
Geoff Jones
Hi
I've just started looking at Access and the Northwind sample database and
have a question which I hope somebody can answer?
In the Order Details table, the OrderID and ProductID fields have keys next
to them and also have "Indexed" set to "Yes (Duplicates OK)".
If I try to reproduce the table in another application e.g. by having
including OrderID and ProductID and giving them keys with "Indexed" set to
"Yes (Duplicates OK)" I get:
"Removing or changing the index for this field would require removal of the
primary key"
i.e. I can either have the keys or "Indexed" set to "Yes (Duplicates OK)"
but not both.
Can anybody help?
Thanks in advance
Geoff
I've just started looking at Access and the Northwind sample database and
have a question which I hope somebody can answer?
In the Order Details table, the OrderID and ProductID fields have keys next
to them and also have "Indexed" set to "Yes (Duplicates OK)".
If I try to reproduce the table in another application e.g. by having
including OrderID and ProductID and giving them keys with "Indexed" set to
"Yes (Duplicates OK)" I get:
"Removing or changing the index for this field would require removal of the
primary key"
i.e. I can either have the keys or "Indexed" set to "Yes (Duplicates OK)"
but not both.
Can anybody help?
Thanks in advance
Geoff