This is a wierd one - maybe I dont understand it (most likely)

I have 2 tables.

table 1 has a field of which a default value has been given in the design of the table.

this works perfect, so if i leave this specific field blank by default, it fills the blank value in as set in the "Default Value"

cool!



table 2 has a relationship to table 1 by ID. so table1.ID is the primary key.

in table 2 there is also another field, and as with table 1 I made a default value for this new field.

thing is, for some reason its not working. So if i leave this field blank, the "Default Value" will not kick in at all.

what am I doing wrong?