Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combo Boxes in Grids
Message
From
31/03/1998 00:33:24
 
 
To
30/03/1998 22:52:13
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Miscellaneous
Thread ID:
00088300
Message ID:
00088313
Views:
33
>OK. Here's the deal. I have a class that has a grid on it. I am not using the data environment. The first column of the grid is bound to a numeric field in an open table that is a foreign key from a lookup table. I put a combo box in the column, set it up to use the lookup table as a record source, and to use the foreign key as a control source. I also set the BOUNDTO property to true. Everything seems to work fine. (Everything is updated properly) The only problem is when I click on the grid cell that contains the combo box, the entire combo box is in blue (no words show up) I can pull down the combo box, select an entry, but when the combo scrolls up into itself after making a selection, the entire combo box has a blue background, and the selection I made is not displayed. The sparse property of the grid is set to .f., and there are no other controls in the column. If I set the bound to property of the combo box back to .f., the combo acts normal, but instead displaying
>the appropriate selection based on the numeric field, it displays the selection that has a list index of the bound numeric field (in other words, if the numeric foreign key is 29, and that is associated with 'Orange' from another table, instead of displaying 'Orange', it displays 'Apple' because 'Apple' is the 29th item when you pull down the list) Any help would be appreciated.
>
>
>Thanks in advance

Does the controlsource got right value?!
e.g.
grid1.column1.controlsource = Orderline.Item_id
grid1.column1.cobItem.controlsource = Item.Item_id

Suppose you got correct Entity Relationship!! ^_^;

p.s. Don't near 'Apple', else Doctor can't help you! hahahaha
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.
Previous
Reply
Map
View

Click here to load this message in the networking platform