General information
Category:
Forms & Form designer
You could easily change the order of the fields in your view and set the 'BoundColumn' to 2 instead of 1. That would get you cWorkOrderNo displayed, and the cLineCode field would still be the bound field.
The other is IMHO, messy. You'd need to show it the same way in the dropdown. In other words, you'd have a view with an expression as your first column (cLineCode + cWorkOrderNo) and cLineCode as column 2. As above, you bind column 2.
Alan
>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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only