>on form1
>BEGIN TRANSACTION
>* create form2 on the form1.datasession
> * on form2
> BEGIN TRANSACTION
> * edit data
> * form2.save -> END TRANSACTION
> * form2.undo -> ROLLBACK
>* form1.save -> END TRANSACTION
>* form1.undo -> ROLLBACK
>
>you cannot edit two form2 at the same time
The biggest problem I see with this approach is that the user might leave the form(s) open for hours, making all the records in both tables (or any table updated in the transactions) unavailable, and even if the user does his/her job fast, there might be many fields to fill with the same effect.
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges