<i><font color="#663300">The view uses Optimistic Record Buffering. No indices on the view.

The child field is marked as not updatable.

All parent fields are updatable.

Now the testing part:

What we noticed in testing the data environment is that we could add a new record to the view without error, but if the record pointer is moved, error 1547 is generated.

The simple solution is to place a value into the one field from the child table. Then the pointer can move. </font></i>

I'm not sure I follow. Why is the pointer being moved? Why do you want to save a blank row to the table? Why don't you use table buffering?

Also, why isn't <b>IsNewAndEmpty()</b> being called during pointer movement? That should take care of the "cannot insert empty row" problem.

<font color="#cc0000"> ___/

/

__/

/

____/</font>

Ed Leafe