Duplicate values in the index, primary key, or relationship messag

  • Thread starter Thread starter Elle27
  • Start date Start date
E

Elle27

After entering a new record into the table, the error message, "changes were
not successful because they would create duplicate values in the index,
primary key, or relationship appears". However, the table the new record was
entered into is designed to have duplicate values indexed while the
autonumber field is the primary key. It is related to a table. The
relationship is one to many. The table the new records are being entered
into is the many side of the realtionship that allows for duplicate values.
Not sure if this is enough information, but any help or insight would be
greatly appreciated!
 
A Primary Key is an index, but additional Unique Indexes can be added.

Open the table in design view, and open the Indexes window.
Ensure some extra junk wasn't added.
 
How are you entering the data? It sounds like you are entering directly into
the many side table. If so how are you entering the foreign key?

You should be using a form/suborm for the one/many data entry with the
primary/foreign keys as Master/Child links.
 
Back
Top