Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grid With A Combo Box
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00399668
Message ID:
00399888
Vues:
9
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform