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