Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combo Box in grid, lookup and display
Message
From
03/11/2000 16:58:09
 
 
To
03/11/2000 16:51:30
Spencer Redfield
Managed Healthcare Northwest, Inc.
Portland, Oregon, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00437864
Message ID:
00437869
Views:
16
>(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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform