Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid: how do I change a column from txt to combo?
Message
From
17/11/2006 08:18:16
 
 
To
17/11/2006 06:41:02
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01170582
Message ID:
01170648
Views:
9
Thank you both! I'm still a little confused as to how to make the user's selection from the combo box populate some field in the grid's/child's table? e.g. if combobox's ControlSource is CITIES.CITY, how do I make the CITY field in the child table (say CUSTOMER.CITY) get populated with CITIES.CITY. I am sure it's easily done with some event. I am just curious if the grid and comboboxes have properties that directly allow for this?

Update:
In playing around with a combobox that I simply added to the form (not to the grid yet), I am confused about ControlSource versus RowSource. I imagine that I could set RowSourceType =Alias and RowSource=CITIES. But how do I specify what field from CITIES is used? Is that where ControlSources is used? If so, why does ControlSource offer a list of all tables/fields from the form's DE? I would think it already knows the RowSource=CITIES - so shouldn't ControlSource only offer a list of fields from the RowSource table/alias?

Update 2:
WOW, what a learning curve :) I pretty much figured out how to configure comboboxes that are populated with multiple fields from an alias. How odd that you get an error if you enter the alias name more than once for fields listed in RecordSource (e.g. RecordSource = "MyAlias.field1, MyAlias.field2" gives an error "'field' phrase not found", but "MyAlias.field1, field2" is correct!). I can see learning VFP is going to be like learning English - lots of exceptions and surprises :)

Sure would have been sweet if RecordSource property offered a list of all tables.fields and you could do a multi-select to set which fields will appear in combobox/list and their order. Now that would have been much more intuitive to a newbie :)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform