General information
Category:
Forms & Form designer
Environment versions
Network:
Windows 2003 Server
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only