>Can anyone shed some light on the reason why I need to put my sibling tables (one to one relationship with InitialSelectedAlias) into TABLE buffering instead of row buffering when editing fields from both tables on a form?? When I switch work areas and run a SELECT into a cursor in the same datasession (which, by the way, does NOT pull from the form's tables) the update trigger fires and commits the record!!! What's up with that??? Is that normal?? If I put the parent in Row buffering, but then put the siblings in Table buffering, the trigger does not fire. Does VFP inherintly commit records (or move the record pointer) when switching work areas (SELECT 0) ?? This seems kinda crazy. HELP.
>
>Thanks in advance

That's sound mormal for pessimistic buffer but I think it work the same for Pessimistic or optimistic where the trigger fires when you go to the next record.