How do I keep numbers from showing in my query instead of text?

[Guest]

I built a database that has forms that will allow a user to enter data in one
form and then view it in another. These forms contain drop down menus that
allow the user options to populate the datafield. All of the data is stored
in one big table that pulls its data from the indiv. drop down menu tables.

I'm building a query that will pull all this data but my drop down boxes
show their ID number (1st column in their table) instead of the text. For
example, for the "name" drop down menu I have an associated table that has
two columns; ID, and Name. When I run my query and want to see the name all
I get is the ID number associated with the name that was choosen when the
user entered the data in the form.

Why does this happen? I want to see the name instead of the ID number. How
do I fix? Thanks for all your help.

 

[Duane Hookom]

You need to include the field with the name value in your query.

BTW: I hope you didn't use the misfeature of Lookup Fields in table designs.
Also, "name" is not a good name for any object in Access since every object
has a name property.