Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combo box to show description instead of code
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00407643
Message ID:
00407653
Views:
20
The problem I had was that I have a generic 'GetData' function to populate a cursor - this was called to create a cursor for the dropdown. PK is the first column. I did it with fields but then had a problem closing the app (something to do with source file not found). My only solution is to do another select from the 'GetData' cursor to change the sequence of fields. No big problem, just a bit of a pain as I'm going to be doing other forms the same as this.

>
>What's wrong with simply setting the order of fields displayed in the sequence so that Description occurs first; depending on what the RowSource for the ComboBox was, it might be as simple as switching the order of fields in a SQL Select, or changing the order of things is the RowSource for an Alias or Fields type list? In dire situations, you can even pull a composite field for the first column containing both Code and Description, and then a second column of just Code - bind on the second column, and now everything is displayed at all times.
Nigel B Coates
NBC Software Services
Dublin, Ireland.
eMail: Nigel.Coates@NBCSoftware.com
Previous
Reply
Map
View

Click here to load this message in the networking platform