Duplicate values error

[Mr_P]

I have a table in access 2010 that has a primary key in the 'Request no' field, that has no duplicates and no zero length., which is updated etc from vb.net.

My question is how do I allow for multiple clients having the same number. For example, client 1 has a number of 011697 but client 2 also has this number.

These numbers are set at input time and have no relationship with each other. If it is not auto inc, do I need to have a primary key on that field or is there another way to tackle this.Thanks

 

[CJ_London]

In that case it cannot be a primary key - by definitition they must be unique.

Suggest you create a new autonumber ID field and make your 'Request no' field indexed - duplicates OK

 

[namliam]

If you want to use this field as a PK, you cannot... the definition of the PK requires it to be Unique.