Don't understand the logic

[Bentleybelle]

I created a db, tested it with dummy info and all was fine. I then imported live data from another db. When I came to add new records, discovered that, in the table design, a default value of 0 (zero) has been entered for fields where a look up table is used (where I had used Autonumber for the ID). Solved that easily enough, but later I amended a text box to a combo box and the same thing happened. Why does it do this?

 

[alastair69]

Some where in one of your tables "Normally" a number field, there is a default value, this normaly sent to a "0" delete this and all should be sweet.

Alastair

 

[neileg]

Some where in one of your tables "Normally" a number field, there is a default value, this normaly sent to a "0" delete this and all should be sweet.

Perhaps not. When a numeric field is null, Access displays this as a zero.