Combo box problem

[Laurel]

I have a combo box who's bound column is a numeric ID, Grant_ID. I set
it's width to 0, and I display two other columns, Funder name and Grant
name. I would like to display those other two columns in Funder Name, Grant
Name order, but have the Grant Name be the value that shows in the field
when the dropdown is not displayed. In order to get the sort order right, I
have to have the Funder Name come before the Grant Name in the query
builder. But when I do that, the Funder Name is the one that is displayed
in the field.

Is there anyway to have the 3rd column show up in the field?

 

[Ed Robichaud]

You can have the same fields repeated in your query, so put [grant name] and
[funder name] in twice (total of 5 columns) but only display the first 3
columns (check boxed). Use the first 3 columns for display order and the
last 2 columns to set your sort order.
-Ed