Help --with error message -duplicate values

[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!

 

[John Vinson]

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!

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).