I am new to FP and VFP and am not used to the default behavior of set deleted. In programming with RDBMS' I am used to a record being deleted once you issue a delete command. One illustration of the problem that keeps popping up for me is a zip code maintenance table. I have a candidate index on zipcode. If an end-user deletes a record in the zip code table(maybe because the city is spelled wrong) and then wants to recreate this zip code the save fails because of the duplicate key.

My first question, Are there any problems, or side effects to setting deleted ON, that maybe I should be made aware of. Also, where is the best place to issue "set deleted on"? I tried to put it in the config.fpw but it doesn't seem to work there. I see by looking in help that this command is scoped to the current datasession, so would I need to issue this command in every form?

Any advice or comments would be greatly appreciated

Paul