MS Access lookup values in query / form
Posted on 2014-03-11
Haven't used MS Access for a while and can't figure this out:
I have a products table that has two columns - "ProductID" (pk) and "Product"
I have an Orders table that contains a lookup column "Product(s)" that uses the rowsource "SELECT Products.ProductID, Products.Product FROM Products;" its Bound col 1, column count 2 and col widths 0;2.54cm
This all works fine.
I then have created a query that filters the order table by customerID.
This works fine - when I view the query I see required columns, including the "Product(s)" lookup column that shows a list of the product names.
As an example in the Product(s) field I will see "Design, Marketing, Brochure"
However, when I try to use this query in a form (continuous form view) it only shows the productID's in the lookup box not the Product(names) I see in the query?
i.e. it now shows "1,3,4"
How can I make it so that the "Product" column (product names) show and not the ProductID field?