Combobox Value List question

[sogibear]

i have a combobox setup as using a 'value list' for data with these values : "YES";5;"NO";3;"DONT KNOW";1

the bound column is set to 1 so that the actual values stored in the db are "YES, NO, DONT KNOW" etc.

however i'm using column 2 to store values to use in A grading system.

basically if someone chooses "Yes", then i want to be able to access and store the value 5 somehow ?

any ideas

Thanks

 

[VicM]

sogibear:

Don't know why you would want to store the text "YES", "NO", "DONT KNOW" in the table. Since you know what the values represent, you would easily be able to handle a conversion in a query or report control.

I would suggest you store the number in the table and set the combobox value list = to 5;"YES";3;"NO";1;"DONT KNOW". Still bind to column 1 and set Column Count to 2 with the Column Widths set at 0";0.5".

You can also do the same with the underlying table's field definition for that data. Then when you view the data directly in the table you will see the text instead of the number, but actually only the number will be stored.

Hope this helps,

Vic