Why am I getting related record required errors for optional FKs

[Dan Neely]

I have a table with several foreign keys that are not required, but whenever
I attempt to add a record without the FKs set I get the error message "You
cannot add or change a record because a related record is required in table
'tblFoo'." When the FK for tblFoo is the optional FK parameter.

 

[Allen Browne]

Open the table in design view.

Select the FK field.

In the lower pane, remove the zero default value.

(MS has solved this in Access 2007: numeric fields don't default to zero
automatically.)