This was exactly it. I had the same problem and the solution was changing the "Default Value" from 0 to Null in table design of the child table.
I have a main table (pk main_data_id). and 2 child tables. tbl1 (fk data_id), tbl2 (fk data_id)
one to one relationship for child tables (main to...