I'm having a problem with one of the filelds on the add new record page.
The data comes from a MS SQL database. When I fill in the data for all fileds and save the record, the field named Month (DB field name Month as tinyint) always gets inserted as zero. I have changed this field to a lookup field and added the 12 months as numbers into the drop down. Regardless what month I select the new records gets inserted with "0" as the value for the field called Month. Can the filed name or the data type be the problem?
Thanks in advance.
