• That's going to be an ASP problem, not a TSQL problem. The dropdown must be sending a 1 when generating the TSQL insert statement.

    You need to modify the dropdown box properties to write the value rather than the item index number.