Boolean default value prevent inserting

[tamas]

Hi,
I want to upsize my Access backend to SQL Server 7. I have a form having as recordsource SQL statement based on 2 tables in a 1:n Left Join relation.
When I try to insert a new record in the form I receive the
error 3101: The Jet engine can't find in "Parent" tabel adequate keyfields for "ForeignKey".
So it tries to insert a foreign key wich doesn't yet exist in Parent table.
In the form I have 2 boolean fields. When I remove the default values from this 2 fields I didn't receive the error. But I need the default values.
Any idea ?

Thanks in advance