Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Full Names in Combo Boxes
Message
From
28/09/1998 04:57:57
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00141197
Message ID:
00141339
Views:
18
Mark:

Thanks a lot for the tip. I'll try it immediately.

John

>>I have a combo box populated with the Last Names and First Names of the client's customers. I am using an SQL Select to load them. My problem is probably pretty simple, but has defied me so far: If the user selects the third Smith, let's say, in the list, any attempt I make at finding the proper record in the table fails--I always get the first Smith. The order of the table is LName + FName, but I can't get the combo box to return anything as a Value except LName. The cursor that the SQL Select creates (csrCustomer) is, apparently, not available.
>>
>>What am I doing stupid??
>>
>>TIA.
>>
>Include the KeyId field from the customer table in your SQL but do not display that column. Use that as the bound column.
Previous
Reply
Map
View

Click here to load this message in the networking platform