combobox value (1 Viewer)

[loki]

I have a combobox that has values from two columns displayed. For example "A Active" "C Cancel" "E Expired" and so on. When you select "A Active", an "A" appears in the text box and is stored in the table. I want to be able to select "A Active" and still have "A" stored in the table but I want "Active" to appear in the text box.

 

[D B Lawson]

You could have it so the user just sees Active, etc in the combo box but stores A etc in the base table. To do this, in the combo box properties, column widths, set to 0;2.5. That way, the A column is hidden but is still the "bound" column.