Help --with error message -duplicate values

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

Please help! I am getting the error message "the changes
you requested were not successful because they would
create duplicate values in the index, relationship or
primary key"
I know that this is not the case! The database has a dual
primary key, and the fields are unique. In fact, after I
get this error message if I close the form and reopen it I
can in fact enter the information.
Any help is greatly appreciated!
 
Please help! I am getting the error message "the changes
you requested were not successful because they would
create duplicate values in the index, relationship or
primary key"
I know that this is not the case! The database has a dual
primary key, and the fields are unique. In fact, after I
get this error message if I close the form and reopen it I
can in fact enter the information.
Any help is greatly appreciated!
Click to expand...

One possible cause for this is if one or both of the fields are
Numbers, and have their default values set to 0 (which is the
"default" default for number fields, annoyingly enough).
 
Back
Top