Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Combo Box in grid, lookup and display
Message
De
03/11/2000 16:58:09
 
 
À
03/11/2000 16:51:30
Spencer Redfield
Managed Healthcare Northwest, Inc.
Portland, Oregon, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00437864
Message ID:
00437869
Vues:
17
>(VFP 6.0, SP3). The issue: I have a grid whose RecordSource is table "A", RecordSourceType is 1-Alias. I want a certain grid's column's ControlSource to be a Combo Box that automatically looks up and displays the description found in table "B". That is, table "A"'s lookup ID field determines which description from table "B" should appear in the Combo Box. The user then interacts with just the description. The point is that the lookup ID must never appear to the user.
>
>A Knowledge Base article, Q138779, "Make a Lookup Combo Box in a Grid", is a bit like the behavior I need but differs in one important aspect. Except when its Combo Box actually has focus, it displays the ID I need hidden, not the description.
>
>I have been unsuccessful in my attempts. Can someone point out whatever I'm missing or direct me to a more appropriate example? Any assistance would be really appreciated!

e.g. :
combo.RowSourceType = 2
combo.RowSource = "cuGridComboSource"
combo.ColumnCount = 1
combo.BoundColumn = 2
combo.BoundTo = .T. && if idfield is numeric

** to get above cursor
SELECT description, idfield ;
  FROM tableB ;
  INTO CURSOR cuGridComboSource
Insanity: Doing the same thing over and over and expecting different results.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform