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


see message#1450264 for a real dbms that never fails