Duplicate keys in a table

[SeniorCitizen]

I'm looking for a way to allow multiple records with the same key but rest of the data is different.
It is a case where multiple occurrences will appear to the same OwnerID and the same month.
The table has an OwnerID, as a number and primary key, indexed and Duplicates OK
Also a Month field as number and primary key.
If this is not possible, as I suspect, is there a better way to accomplish this?

[Minty]

If the month was an actual date, would you ever have a duplicate date?
I'm puzzled by the requirement really, If this was a sales table, you have a SalesID - unique primary key, a CustomerID not unique in the sales table, but unique in the customers table.

What/why are you worried about saving a duplicate value if what sounds like a related table?

What is the data and what are your tables?

[ranman256]

keys prevent duplicates.
add another key?

[Micron]

I'm looking for a way to allow multiple records with the same key but rest of the data is different.

Consider composite index. I can't recall if I've ever used Allow Dupes with a PK field. It doesn't make sense to me. Even if I have a composite index I have at least an autonumber PK field so that every record has a unique identifier - just in case.

[SeniorCitizen]

I have a work around. Thanks

[Welshgasman]

I have a work around. Thanks

Well, please share it.
Therse forums are to help others after all?