edlentz
Posts: 11
|
Posted: 05/20/2004, 4:21 AM |
|
I need a listbox or dropdown box that when activated it would show a list from an inventory. I would want 2 - 3 fields of the record ie: part #, description, price. The example of Order Entry does almost all I want except this. Can someone comment?
Thanks
Ed Lentz
|
|
|
buzz
Posts: 11
|
Posted: 05/20/2004, 8:37 AM |
|
Use sql to concatenate the fields you want:
select field1, concat_ws('-',field2,field3) as textcolumn from table
In the properties box you should now be able to select field1 as the bound column and the field textcolumn as text.
Above is the concatenate syntax fro MySQL
|
|
|
edlentz
Posts: 11
|
Posted: 05/21/2004, 3:25 AM |
|
Thanks Buzz, but wouldn't that make for one long text line? I am looking to see some type of columnar setup, similar to a combo box. The user might not know the part number but might know something of the description or vice versa.
|
|
|
|