binding columns from combo box

[uscitizen]

this should be a snap but then why am i writing....

i have a text field in a table. it's value should be chosen from a combo-box. the combo box has two columns. col 1 is a number field and col 2 is the text/value i want to bind to the table. i'd like the user to view both columns in the combo box when (s)he hits the drop down arrow.

using nothing more than the design interface of the table can i not do this. before throwing in the towel, i got as far as getting the drop down button to display the pair of column in the combo box, but the value that's getting bound into the text field of the table is from the (leftmost) number field of the combo box.

 

[uscitizen]

supplementing what i wrote earlier......

i found that by reversing the order of the fields in the design of the combo box (i.e., col 1 in the combo now contains the info to be bound to the text field in the table and col 2 of the combo holds the referential number values) that it worked.

go figure!

 

[randysmid]

Hi,
You can still do this, but you need to check the Bound Column property of the combobox selection. You will find it under the Data tab (in Properties). HTH,
Randy Smith
California Teachers Association