Oops, you're right, Dan. I should have checked for the FIRST (parent) lRet before running the second:

Begin Transaction
SELECT Parent
lRet = tableupdate(0,.t.)
if !lRet
   Rollback
endif

if lRet
   SELECT child
   lRet = tableupdate(1,.t.)
   if !lRet
      Rollback
   else
      END Transaction
   endif
endif

Thanks for the quick correction
Barbara


>>Note that I tested the return value for each TableUpdate() command, and did a RollBack if necessary. The first parameter in TableUpdate determines whether ALL records are saved or just the active record. Check Help for more information.
>>
>>HTH
>>Barbara
>>
>>
>>
>>
>>>Should I wrap the whole thing into one transaction? Or do I have each record added as entered? I like the PageFrame idea.
>
>Isn't it possible to have the two files get out of synch when handling it that way?