Displaying Value and not ID

[Jonny]

I am trying to show in one field three values, but instead value I see its ID.
Any advice how to display three values?

Attached a database.

 

[wazz]

comboboxes only show one column. but if you join a few values together you can see them all.

3 columns: 'id', 'firstname', 'lastname' will show one of those three (the first column where column width > 0).

2 columns: 'id', 'firstname & " " & lastname', where width of column 0 = 0 and width of column 1 > 0 will show the first and last name joined together.

 

[Jonny]

The problem is not to show column , but show the "readable" content of this column. Instead seeing ID numbers like 9353, 9434 ... I'd like to see Renault, Toyota,...
Could you help?

 

[Fifty2One]

Go into the Row Source properites of the combo and click into the build so you see the graphical representation of the query and drag the ID field to the end of the query.

 

[music_al]

like this ??

 

[wazz]

comboboxes only show one column: the first column with a width > 0.

 

[Jonny]

music_al, I want to display in one combobox three fields, for examples:

XXX   |   Renault   |   Clio

from table Models

Thanks all, I found the following solution:

SELECT DISTINCT Models.SamplesID, Models.CatalogNumber, Manufacturers.CompanyName, Models.ManufacturerModel
FROM Manufacturers INNER JOIN Models ON Manufacturers.ManufacturerID = Models.ManufacturerName;

Where the 'Column Count'=4: