A combo box I created has it's "RecordsourceType" set to "2-Alias", and the "RowSource" set to "lvWeighStation", where "lvWeighStation" is a local view, which gets the "clinecode" and the "cworkorderno" (in that order) from two differnet tables.

When I select from ComboBox, the "clinecode" is used as the "DisplayValue/Value" of the box.

I wish that the second column, "cworkorderno", be displayed as the "DisplayValue/Value", or better yet the "clinecode" along with the "cworkorderno" (column 1 & column2).

Is this possible?