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.