Can save one record, can't save two

E

elefink2

When I try to save a second record in my database, I get the following error:

The changes you requested to the table were not successful because they
would create duplicate values in the index, primary key, or relationship.

I suspect that it has to do with the date field. I have a date field in 6
realted tables all being accessed by a query. The form is based on that
query. How can I fix it?
 
B

Brian

Look at the underlying table. One of the fields probably says Indexed (No
Duplicates) in the Indexed property. This is appropriate only for items that
make the particular record unique, such as a customerID, etc. Change it to No
or to Yes (DuplicatesOK). That is, this number should show up on only one
record.
 
Top