Claude,

Too bad you don't have the INDEXSEEK() command. It doesn't move the record pointer (unless specifically instructed to) so you wouldn't need to USE ... AGAIN.

If the uniqueness of the CACCCODE index is violated but it is not in the table you're working with, do you have any database triggers when a record is added which do something in another table (the one with the CACCCODE index?)

Do you possibly APPEND BLANK before adding a new record, and since the key field is blank it runs into conflict with another blank?



>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