What are the buffering setting for the view and the underlying tables? Can you post the code that creates View and sets it's properties?
Also you should use RIGHT JOIN if you want to see master records w/o child records.

>I have created a view in code using 'Create SQL View' that includes a master table and 4 other child tables. The child tables are all left outer joined to the master table (Master table is on the left). I've allowed the fields in the master table to be updated using DBSetProp(). The problem arises after a new record is appended to the view. When the record pointer moves in the view the following error occures:
>
>'Cannot insert an empty row from a view into its base table(s)'
>
>Before the record pointer moves there is data in one of the fields in the master table. But it prevents the appended record from be updated to the base table. Also, I do not want to add a record to any of the child tables when the a record is appended to the master table.