Jim, because when a record is deleted you can RECALL it (undelete) the primery index which index any record in the table (you can have it filtered but it is highly not recomended) will not allow a duplicates even with deleted records recycling is RECALLing and blanking all the fields but the index Arnon > I want to recycle the deleted records in a table. Lets say the table is > 'table1'. The 'table1' has a primary index on the field 'NO'. I have a > record with the 'NO' value 5 and the record is marked deleted. If I append > a record, set the 'NO' value 5. The message 'Uniqueness of index NO is > violated'. I tried set deleted on. It won't help. > > To my knowledge, if the record is marked deleted when the set deleted on, > logically it does not exist. Why I have the key violation? I don't > understand. Help please? > > Jim S >