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

"Real" DBMS don't have deleted records at all, instead the records are flagged as reusable, and reused whenever necessary. They also don't have "record numbers". Do you know any other DBMS than xBase which has a "recall" command?