You can either PACK the table and thus remove the record or RECALL the deleted record The problem occurs because VFP doesn't really delete records when you DELETE them, it merly sets a flg on the record as deleted (and then filter it out if SET DELETED is ON setting UNIQUE will not matter this command affects REGULAR indexes and it tells it to store only the first occurence of any key (it doesn't prevent duplicate keys either btw) >I have a table with a candidate key. >When I append blank, and delete it, leaving the candidate key field blank. > >And when I try to append another blank record, the error msg >" Uniqueness of Index feildname is violated " > >What can I do to overcome this problem? >Should I set the UNIQUE OFF or ON in the form initialise event, will it help?