Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid With A Combo Box
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00399668
Message ID:
00399888
Views:
18
>Steve,
>
>That sorta worked.
>
>On the combo box, I have RowSource as:
>
>SELECT RecordId, Desc FROM Inventory ORDER BY Desc INTO CURSOR Temp1
>
>and RowSourceType = 3 (SQL)
>
>When I run the form, I see the RecordId in the combo, not the description.
>But I want the RecordId to be bound to the Orders table ItemId field.
>
>Not sure what I'm doping wrong here
>
>Any ideas?

I have a wild idea: in you RowSource use:
SELECT Desc, RecordID FROM Inventory ORDER BY Desc INTO CURSOR Temp1

(e.g. Desc should be the first).

Also you should know, that you can not use Desc as a field name. It should be Descr at least to not confuse with DESCENDING word in FoxPro. It may be your other problem too...
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform