>>>Set deleted on/off is scoped to the current data session, so you may have to issue it again in the form. Personally I never delete records, instead I have a logical field called reusable. When I add a new record, I first check for available reusable records. This is how "real" DBMS works.
>>>
>>Tore,
>>
>>Can you give a sample of DBMS where it works this way?
>>
>>Thanks.
>
>Internally every "real" DBMS works this way, but it's not exposed. I don't want to spend time to prove my point, unless you can prove me wrong.

I don't know how the real DBMS works behind the hood, may be you can send me some links explaining how deleted records are handled.

Thanks in advance.