Posted on 2010-11-09
I'm trying to populate a combobox with two fields from one table and then save a value to another table.
RowsourceType = 6 (Fields)
Rowsource = Table1.Field1,Field2
BoundTo = .T. (I've also tried .F.)
Style = 2 - Dropdown List
The Rowsource table is just an index field and a description, both character fields.
I want the combobox to display Table1.Field2 and when a selection is made I want to store Table1.Field1 to Table 2.
What's happening is that nothing initially displays in the combobox. When I click on it, I see the items from Table1.Field2, as I should. But when I click on an item, I see the value from Table1.Field2. That is the value I want to store in Table 2, but I don't want to display it in the combobox after I make a selection.
For instance, when I click on the combobox I see Choice1, Choice2, etc. But when I select one of them, I see 01, 02, etc., which is what I want to store in Table 2, but not display in the combobox.
If it makes a difference, both tables are buffered,3.
I've tried using the Builder, with the same results. Any ideas? I've been at this for two days now.