The Developer's Guide, in HTML Help, has a few good examples. A simple one would be:

STORE .F. To lParentOK,lChildOK
BEGIN TRANSACTION
lChildOK=TABLEUPDATE(2,.F.,"childtable")
lParentOK=TABLEUPDATE(2,.F.,"childtable")
IF lChildOK AND lParentOK
END TRANSACTION
ELSE
WAIT WIND "You got a problem" NOWAIT
ROLLBACK
ENDIF




>Hi John,
>
>Thanks you for your solution. So far it is working well.
>
>You mentionned bufferng both tables and wrap TABLEUPDATE into a TRANSACTION, to ensure that all changes are saved or lost. Do you have an example of how to do this?
>
>Thanks again