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.

[RuralGuy]

You should really *not* be using Lookup Fields. http://www.mvps.org/access/lookupfields.htm
...and you don't really want more than one value in a field.

[jonny]

So what the compensation to "Lookup Fields"? Because ManufacturerName field can be duplicated I want to show CatalogNum and ManufacturerModel too.

I found the following solution, where the 'Column Count'=4:

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

[RuralGuy]

You can easily display just about anything you want in a query which is fine. Just don't use Lookup Fields in a table. Using ComboBoxes on forms as a Lookup is also just fine.