Query with lookup field in table

H

hmulks

I want to run a query to determine all items on the "First Floor". In the
table I am running the query on, "First Floor" appears in a column titled
"Area". when completing the table a pulldown list appears to choose the floor
(First Floor, Second Floor, etc.). These floor names are looked up from a
table"Locations". I would like to display "First Floor" in the completed
query. Right now, if I enter the ID from "Locations" I can display the other
items but it just gives the value from the ID column not the name of the
floor. How can I display the name?
 
R

Rick B

Include the related table in your query (Locations) and make sure the link
between the two tables is correct. Then pull the location name from the
Locations table, not the number from your main table.
 
Top