Hi Mark,

Interesting problem. Perhaps you need to rethink where you put your validation, or, alternately, isolate the child into a buffered view. Then, when saving, use GETNEXTMODIFIED to go row by row through the view and do a TABLEUPDATE for each row, forcing the validation.


>Buffering problem. I have a one-to-many form. Parent table buffered 3-Optimistic, Child is table buffered.
>
>I use regular controls to enter data into the child. I also maintain a read-only grid so the user can see all of the children that have been entered. The whole function (including add/edit/delete/save buttons) is wrapped up in a VFP container
>
>I have row validation set up for the child table in the DBC. This validation fires when I move the record pointer. What do you do on the last child record? The pointer hasn't moved and the validation doesn't fire. If I click OUT of the container and try to save the parent/children BEFORE the child valid executes, the form errs out.
>If I force the valid to fire (by entering another record, then immediately deleting it), then the save goes right through.
>
>I'm sure there is a simple solution for this. Any help would be greatly appreciated.