Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Displaying multi columns in Combo Lists
Message
From
30/01/2003 07:37:12
 
 
To
30/01/2003 06:28:55
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00747033
Message ID:
00747071
Views:
15
>Hi Rosendo.
>
>I have a three column drop down combo list and I want to show the fisrt two columns as the display value.
>
>The DisplayValue of a combo box always comes from the first column in its RowSource. So if you want to display the first two column when the combo is closed, you have to set the combo up like this:
>
>
>RowSourceType: 3-SQL Statement
>RowSource: SELECT ALLTRIM( LastName ) + ', ' + FirstName AS FullName, IDNumber from MyTable ORDER BY LastName INTO CURSOR MyCursor
>BoundColumn: 2
>BoundTo: .T.
>
>
>HTH

Thank you Marcia. It worked pefectly !!!!!
Rosendo J. Roche
Previous
Reply
Map
View

Click here to load this message in the networking platform