Default value doesnt work?

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?

How is your table schema written? Have you actually set a default for this field?

Regards

Please show the db-schema (the create table scripts), the pk-fk relationships and the query that you use to test this functionality.

It should not happen as long as the relationship is not invalidated! What database server are you using?