Can't make composite key.

[Hans]

Hello. I am trying to make a composite primary key for a table with a field for ID and REGIONID, but am not allowed to save it with these changes. I am given the "changes unsuccessful...duplicate values in the index, primary key, or relationship..." message.

I have tried all I can think of. Do I need to pick another primary key(s)?

 

[RV]

Does your table already contain data?
'Cause that's the normal reason you get this message..

Remember that the combination of ID and REGIONID must be unique.

P.S. Two "ID's", are you sure your databasestructure is properly normalized?

RV