If I create a valuelist from a database, I can specify up to three columns that are shown in the popup list. Typically, I use two, a code and a description. In a type-ahead field, all columns are searched for matches when typing in the field. But I’m also using setvaluelistitems to populate valuelists that have more than 500 entries. I can only specify one column to display. I can concatenate the code and description to show both, but it is still only searchable by the starting characters of the concatenated column. How can I use setvaluelistitems to show and search on more than one column?
that is not possible
but in 5.0 we have a new way of filling the typeahead with values and that is by using a global method as the valuelists data provider.