Let's say that table2 contains values "1" and "2" in field2, and that I try to insert in table1 the values "1" (and there is no problem) and $null$ (and the error appears). Although field1 in table1 is nullable, the insert of null values is not admitted in this situation and I get the above error.