Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Popluating combos
Message
From
07/07/1999 09:19:05
 
 
To
07/07/1999 07:21:53
Nikki Bannister
K&M Computer Systems Ltd
Birmingham, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00238171
Message ID:
00238218
Views:
16
Hi Nikki.

>
>The problem is they now want an option to select "ALL", this is not stored in the table. Could you please give me any idea's how to do this. Also "ALL" needs to be at the top of the combo's.
>

IF You set the RowSourceType of your Combo to SQL you can use something like this as the RowSource:

SELECT Yada, nada, blah from SomeTable UNION Select ' -- All -- ' as yada, SomethingElse AS nada, YetSomethingElse AS Blah from SomeTable ORDER BY Yada INTO Cursor MyCursor.

Then, in the valid of the combo, you would have to take some specific action if ' -- All -- ' was selected.

Marcia
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform