I have 2 columns that populate my combo box. They come from a table where I manually wrote in an ID
and a clean_value
field.
The goal:
Display both columns on a combo box on a form. The ID
values should be on the left of the clean_value
values when looking at the drop down list. When selecting something in the list, the combo box should display the clean_value
, not the ID
. When saving the form, the form should write the ID
value to a different table.
What I've tried:
I set up the table to get the values from. I set up the combo box to show the 2 values in the correct orientation. The ID
value is the value that is being written to the table.
The problem: When the user selects one of the values in the list, their selection shows the ID
. I want to display the clean_value
upon selection instead. How do I do this?
clean_value
, secondID
and setbound column
to 2. – BitAccesserID
column on the left? – whatwhatwhatColumn Widths
. Set first to 0 (they are separated with;
) and changeColumn Count
to 2. – BitAccesserclean_value
after clicking. – whatwhatwhat