I have a dropdown listbox with an array data source containing the following columns:

machine_number, machine_name, machine_rate

The bound column is column1.

However, I want the machine_name to show up in the box after a selection is made, because the users prefer to see the name not the number. But when the box is 'dropped down' I want to see the columns in the exact order shown above... (number, name, rate)

I have found that regardless of the bound column setting, the value in column 1 is the value that is displayed when the box is collapsed.

I have learned that I can re-arrange the array to (name, number, rate) and I get the desired dispay results in the collapsed state, but the dropdown state is not what I want.