Table and its query reflect the combo box ID equivalent, not the text result

[graccess]

Whats the best way to show the text result of a combo box selection when displaying the information through a query? I notice the table is also reflecting only the numerical ID result of the selection so I'm not sure how to take this result and display it as a text result to the user.
thx!

[June7]

Include the lookup source table in the query by joining on the PK/FK ID fields. This will make the associated text value available for display. Joining tables in query to make related info available is basic concept of relational database.

[graccess]

I have various queries where I'm joining tables as well as junction tables for my many to many relationships. Still only displaying the number ID references though. My combo box and option group values are entered through value lists on a separate form. Maybe that's the issue? I'm missing a step somewhere or I have only the bound values selected and I need to disable it. I have the properties for those fields in the query also set to Text box in their lookup column, didn't seem to matter.

[June7]

Couldn't make sense out of any of that. You will have to provide more info about data structure. What is related to what? If you want to provide db, follow instructions at bottom of my post. Identify objects involved.

[graccess]

Ha. Ok, lemme give it another shot, I’m still a newb so please forgive the ignorance.
I have a form with a few multivalue controls such as option groups and combo boxes where I’ve inputted the various choices(values) in the form itself, not a table, however those fields are bound to my main table. But when a selection is made, only the numeric ID is getting stored in my table, from what I can tell. If I had stored these label choices in a separate table as unique fields I suppose then including those tables in a query would solve my problem? Before I go and change my db design a bit, is there a way to programmatically display the text value of these control choices instead of the corresponding numbers?

[June7]

An expression in query, like:

SELECT *, Choose([fieldname], 0, "this value", 1, "this value", 2, "this value") AS SomeName FROM table;

Search Access Help/Web for more info on IIf(), Switch(), Choose() functions and creating fields in query with expressions.

[graccess]

Will try that. Many thanks.

[graccess]

Thanks again, the Switch() function worked. I'll be using that a lot, need to remember to keep those table data types set to number though.