Hmmmm...I have a very robust database system currently in use and development. This is somewhat of a tough question to explain because of all the different parts involved. Basically, I have a Dynamic Query form set up that feeds results to a report. I also have a table entitled "tbl_task_key" that holds task numbers and descriptions. Is there any way I can have the report results pull up the task "text" description instead of the number itself? IE, every task has an integer associated with it. You'll have to take a look at my db to understand.
I can not attach my db here because it is too large, even zipped. Post a response with your email addy and I will send it that way.

Thanks!

Take the query that feeds the report, add the task table to it, make sure it's joined on the task key, and add the task description to the output.

They query that feeds the report is generated dynamically, so it changes everytime. Will this work?

Sure, you just have to add the task table with the appropriate join when you build the query, including adding the description field to the output. It may help to build one in the QBE that gets the results you want, then switch to SQL view to see the proper structure. Then you should be able to incorporate it into your dynamic code.

By the way, this type of "lookup" table is very common, as are the methods of getting the description instead of the code.