> In my system, delete record is not an avoidable event. > I delete the record by delete command only(mark the record deleted), I > physically remove them sometime in the program by the Pack. > When the record is marked for deleted, it still violate the pirmar key > rule. If the deleted record have the same key value. > How can I solve this problem? I solve it by include !deleted() in the > primary key definition. Is it the best method? the best way is wither to recycle the deleted record (IE clear all the other fields and RECALL it) or use a primery key which is not data depended (ie that you can delete and forget) Arnon