Table allowing duplicate primary keys

[Count Duckula]

Hi,



I've set up a table with 2 primary keys but it is allowing me to input the same combinations twice!

Not sure what's going wrong.

[JoeM]

Sounds to me like you haven't successfully set up the table to have a multi-field primary key.
If done properly, if you go to the Design View of the table, you should see a key to the left of both of those fields.
Do you see that?

[Count Duckula]

Yeah there's a key next to both fields. I've set up tables with multi-field primary keys before and not had this problem.

[JoeM]

Yeah there's a key next to both fields. I've set up tables with multi-field primary keys before and not had this problem.

I don't see how that could happen, unless you really do not have duplicates.
Check for trailing spaces or other minor things who could make entries that "appear to be the same" really not be the same.

Other than that, I think we would need to actually see an example of this. You can upload a database showing this (just be certain to remove any confidential information).
I cannot download files from my present location, but can from home tonight. Or someone may take a look at it before I get a chance to.

[Count Duckula]

Sorry it's just me being a complete idiot. Of course it doesn't allow duplicates sorry.