>>>If it works for you it's Ok, i just wonder how it can work, because "INDEX and REINDEX always ignore SET DELETED and index all records in the table" (VFP Help).
>>
>>Ed, I would guess she was doing a search for the ID code and the deleted record wasn't found with SET DELETED ON.
>>
>>Barbara
>
>Yes, but appending new record with this code will fire violation. Or she doesn't use primary/candidate key?
My interpretation (not necessarily correct) was that she was doing a search BEFORE the append blank, and the search was missing a key that was deleted.
Hopefully, she's got everything working now.