Duplicate values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a table containing customer information. The unique value consists of
a customer ID like this, 000000-0000, and it has been set it to Indexed - no
duplicates allowed. This table is related to another table with more specific
information, orders and the like. However, against the rules, I can enter
duplicate values with the same customer ID already existing in that table.
How could this happen? Hope someone could help me.
 
The first one, i.e. the 1 in the "1 to many" relationship. This table shall
not contain duplicate values.

Stef

"Lynn Trapp" skrev:
 
I entered a new record using an existing customer ID. And it was accepted!
although I designed the customer ID to be indexed and no duplicates should be
allowed. On the other hand I was not permitted to delete any of the other
entries because of the relation to "many"-side table.


Stef
 
Let me try to reword the question a bit. You said that this field has values
entered in the following format: 000000-0000. I am assuming this is a text
field. Are you absolutely certain that the values you think are duplicates
are actually duplicates? What have you done to verify that is the case?
'123456 -789' and '123456-789' are very similar, but are not duplicates.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html
 
Back
Top