In a valid of a form I get the error message

Uniqueness of index CACCCODE is violated.

for SEEK, LOCATE, and GOTO commands. The table does have
this index. I am not using it in these commands. I checked and
there is only one record with that key. How do I figure out what is
wrong? I am using VFP 5 and what I am trying to do is see if a record
already exists. Approach is to do a USE ... AGAIN name, SEEK in
name, if found get record no, and then goto that record no in original
table.

TIA