[this may be a repost of a partial message sent earlier by mistake...if so, sorry about that.]

I have data in a parent table, CSN (clients), and related records in ClientConditions (medical conditions). When a new client is entered, I want
to require at least one condition. I want to update the tables with views (table buffered).

The main form updates CSN records. In another, modal form (w/default data session), called from the main form, the user chooses the entries for ClientConditions.

So i have an UpdateCSN view and an UpdateClientConditions view. I wrap the updates in a transaction, updating UpdateCSN first, then UpdateClientConditions. The update of UpdateClientConditions fails (I've checked out the view in interactive mode and the update works fine).

I can add more details, but I just found the following in the Hacker's Guide (under TableUpdate):

"In later versions of VFP, failing to either commit or revert changes before closing a form is the same as reverting the changes."

Does this mean that a tableRevert will be done when I exit the modal form and then when I do the transaction, the TableUpdate will fail for that reason?

Obviously I'm confused. Input is appreciated.

J