>>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.