Lookup field is working, but I'd like to see a value other than index number

[anyclark]

I hope the jpg makes my question clear. In my case, the Asset table contains Model (a lookup field). The Model table defines associations between Manufacturer (e.g. Dell), Model (e.g. OptiPlex 7050) and Type (e.g. Desktop).
Over in the Asset table, it's able to show a drop-down field showing all three of these data elements from Model at once, which is good. But I'd like it to show "Model, OptiPlex 7050; Manufacturer, Dell; Type, Desktop". Instead, it's showing "Model, Optiplex 7050; Manufacturer, 1; Type, 1". Because Dell has autonumber 1 in the index field ManufacturerID in the Manufacturer table, while Desktop has autonumber 1 in the index field EquipmentTypeID in the EquipmentType table.

[June7]

Advise not to build lookups in table. Build combobox or listbox on form. http://access.mvps.org/Access/lookupfields.htm

RowSource would have to be an SQL statement that joins tables in order to retrieve descriptive info.