This Error is driving me crazy!!

[Ali]

Please help - I have a simple database with customer
orders and information and I have suddenly come to a dead
end trying to add a new record.

I can add one new record without any problem but when I
try to add a second one, I get the Error message "The
changes you requested to the table were not successful
because they would create duplicate values in the index,
primary key, or relationship. (Error 3022)"

I have checked the relationships, indexes and Primary key
(which is an autonumber - CustomerID, with a single
relationship to my Orders Table)

I am nowhere near reaching the size limit (just over 3MB
so far) and am going mad trying to work out why I am
suddenly getting this error.

Please Help Me!!

 

[Ken Snell]

Do any of the indexed fields contain a Null value? And is the index that
includes that field have "Ignore Nulls" set to No?

 

[Ali]

I have checked all the indexes and changed any that
specified 'Ignore Nulls' as No to Yes but I still get the
problem.

Ali

 

[Ken Snell]

I can't see the data that you're trying to load, so I'm very limited in what
suggestions to make beyond this.

Can you post the info re: table structure, table indices, and data that
loaded and data that is rejected?

 

[Ali]

Hi Ken

Thanks for your help but I think I have solved the
problem - some default values appear to have sneaked in
to a couple of the fields and removing these has also
removed the problem...

Thanks again
Ali