I want form value from drow menu to go to two database fields

Hi,

I have a form with a drop down menu, and once they pick the value I want it
to go to two fields in the database.

<select name="color">
<option selected value="Red" >Red</option>
<option selected value = "Yellow">Yellow</option>
<option selected value = "Green"> Green </option>

</select>

I want the "color" to be updated in the database, and I also want the
following;

Select case color
Case "Green"
Field2 = 1212
Case "Yellow"
Field2 = 1213
Case Else
Field2 = 1214
End Select

So after the user selects a certain color, and a submits the form the
database fields; Color and Field2 are updated.

I am sure how to do this.