Arthur Klisiewicz
|
| Posted: 07/29/2009, 8:20 PM |
|
I placed a dropdown listbox on the RECORD FORM. This should be used for
lookup from another table. Programing for desktop APPs I used to have drop
down list with several columns sometimes.
How can I have a dropdown display more than one column from this lookup
table (if it is possible at all) ???
Arthur
|
|
|
 |
RonB
Posts: 228
|
| Posted: 07/30/2009, 1:25 AM |
|
use sql: use concat_ws() in mysql
select id_column, concat_ws(' ',column1,column2,column3) from dropdown_table
|
 |
|
MichaelMcDonald
Posts: 640
|
| Posted: 08/02/2009, 7:13 PM |
|
Are both columns to be displayed fields from the same record?
_________________
Central Coast, NSW, Australia.
|
|
|
|
RonB
Posts: 228
|
| Posted: 08/05/2009, 1:20 AM |
|
Yep!
|
|
|
|
|
