Mike,
We almost got it. What I need is as follow:
(1) Field1 (that has the combo box with two columns, eg "1","APPLE"...)
(2) At Field1, when the user select "1" from the combo, the value "1" will be store in Field1 (that is the default), but I also need to store "APPLE" in different field in the table, e.g. field2.
Thanks in advance.