I am currently trying to design a database to ultimately be used in my office. I have designed a form to enter data and the form mostly consists of drop down combo boxes. The drop down menus show two colums: a code # column and text information which corresponds to the code#. The way the form is set up , the code#, not the text, is stored on the form. Now I want to generate a repot but, I want the corresponding text to appear on the report, not the code #. Is there a way to do this?

In the query that supplies the report add the main data table and the table with the code descriptions. Link them via the code field and then select the description as the output for the query / report.

Col
:cool: