This might be a re-post ,, if so my appologies.

I would like an example where explicit transaction control is
used and is error prone, Catch required fields ,, and Rollback
to a Retaning State co that you could re-try the
operation if it faild.

Here is my idea : I have 3 queries that have to be posted in a
sequence beacause of FK_Constraints,, I have to use Post sice
one data_set does require it.

I DO NOT have a grid ,, i have a form with many edit fields and
a "OK" and "Cancel" button.

PLEASE Help ?

Thanking you
Wayne Forrest.