>>>>>>>>>>>>>
Hi!

Even if record is deleted in VFP table, record still exists PACK used. As result, all indexes use this record for indexing. You should eitehr change the logic of unique key generation or add a filter to the index to filter out deleted records (I don't know exactly if last thing will work).

>PART_ID is primary index key, the orginal PART_ID(e.g. 01-001 ) record have been marked delete(), but not PACK. User add a new PART_ID, same number (01-001), and updated by tableupdate() function in our application EXE file which build up by VFP6. The error message "Uniqueness of index PART_ID is violated" displayed. Please help! What can I set unless change the type of index key.
>
>thank you
>>>>>>>>>>>>
You could reuse deleted records, if for ex. 01-001 has been deleted, seek on that deleted record and recall it with the new PART_ID number, this way you will not get "Uniqueness of index PART_ID is violated" .