Materix
|
Posted: 09/13/2003, 1:32 PM |
|
When creating a list box it is necessary to supply a value for 'bound column' and 'text column'.
My question is, if it is possible to display multiple text columns for a list box?
E.g. for a staff-table, you might wan't to display 'last name, first name'.
|
|
|
RonB
|
Posted: 09/13/2003, 3:09 PM |
|
use concatenation in the query that retrieves the values for the listbox =>
select user_id, concat_ws(',',last_name, first_name)name from some_table
if you now select name as the text column the drop down would show lastname,firstname
RonB
|
|
|
Materix
|
Posted: 09/13/2003, 4:23 PM |
|
Thanx Ron.
That solved by problem.
|
|
|
|