Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Picklist
Message
From
16/12/2002 12:22:05
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
CodeMine
Title:
Picklist
Miscellaneous
Thread ID:
00733334
Message ID:
00733334
Views:
50
I need suggestions on how to handle a picklist from a combobox.

I have an order table that needs one package definition record associated with it. The package definition table only has its primary id and a description field. I am assuming that I will need to store the package definition's primary id to the order table. When the user is entering a new order, they have to select a package definition from the combobox. Also, the package definition table has a child table with the packages that belong to it. So when the user selects the package definition, the packages for the definition need to be the current records selected in the package table.
Currently I have a relation set up from the order table to the package definition table and from the package definition table to the packages table. My question is, what is the best way to handle the loading and refreshing of the combobox lookup? I am currently using the default foxpro methods and properties to handle the combobox. The settings I am using follow. ControlSource = orders.packdefid
BoundTo = .t.
Boundcolumn = 2
RowSource = packtemp.desc,packtempid
RowSourceType = 6-Fields

This configuration seems to be working, but I have a strange feeling that I am breaking something in the CDE. I have noticed that when I select a definition in the combobox that the record moves in the table. This, I am sure, is breaking something in the relations set in Codemine.

Can anyone give me any pointers on how to handle a picklist like this in Codemine? I looked around in Codemine for an example picklist type combobox, but the only thing that is ever done in the examples is to just load the combobox with values like haircolor Black, Brown, Red, etc and then the controlsource just gets the value from where ever the color is positioned in the combo itself. I just need to know how to handle the situation when the values are actually coming from a table.

Thanks.
Next
Reply
Map
View

Click here to load this message in the networking platform