I'm having a little difficulty understanding how VFP treats deleted records. I understand that a deleted record is not removed from the table and is just marked for deletion. I was under the impression that if I "SET DELETED ON", I could code as if the records marked for deletion were not there.

I posted a similar question a little earlier but I didn't get a response. I have a table with 4 fields. zip_pk, zip_zipcode, zip_city and zip_st. 2 indexes Primary is zip_pk and a candidate zip_zipcode.

If I delete a particular zipcode and then try to recreate it I get a uniqueness violation. So I changed my base form class to put "SET DELETED ON" in the load event. This didn't do the trick. There has to be a way around this without issuing a pack? Isn't there?

sorry to be a nuisance

Paul