ComboBox question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with a lookup field called fldDeviceDescription. This field
has a comboBox lookup to a table called tblDeviceLookUp, which has 4 fields;
fldDeviceNo, fldDeviceCompany, fldDeviceName, fldDeviceModelNumber. I want my
users (via a form) to be able to choose the appropriate device and display
the last 3 fields of tblDeviceLookUp. I don't want them to have to pick the
Company, Device Name, and Model number separetly.

Is there a way to display multiple fields of a combobox lookup in a single
field of the target table?

As always, your help is greatly appreciated.

Robert
 
You could create 4 combo boxes, all of them bound to fldDeviceDescription,
but with each of them displaying a different column from tblDeviceLookUp.
Then, regardless of which combo box the user chooses the device from, the
others will automatically change to the same device.
 
Back
Top