I have two combo boxes which display both a manufacturer ID and
manufacturer
name. The first box has column 2 bound (manufacturer ID) and the second
box
has column 3 bound (manufacturer name). The first combo box successfully
selects and delivers the manufacturer ID to a textbox on the data entry
form
(and from there into the mfgr ID field in the table); likewise the second
combo box delivers the manufacturer name to a textbox on the data entry
form
(and from there into the mfgr name field in the table). So everything is
working, but it seems silly to have two combo boxes when one should be
able
to do the job, i.e. the ID and name both show in the combo box. I can
live
with what I have but it wastes space - is there a way to just use one
combo
box?
