Thanks for the answer. It seems that I didn't mark the key field (as key fields) for the non-updateable tables in the view. As soon as I did, everything worked fine.

John

>Hi,
>It seems some fields in the table set as NOT NULL in SQL database.
>You may change the table setting OR update the field with SPACE or 0 (depends on the data type).
>
>Wilfred
>
>>I have a remote view (SQL) with 3 tables. Only one is marked as updatable. When I try to save a new record I get an ODBC error that a NULL value is not allowed in one of the fields in a table that is not being updated.
>>
>>TIA
>>
>>John