ID/Value for Report

[dstrain]

I have several fields on a form that stores the ID for the field. I use my form to filter records and then generate the report from a button on the form so it is also filtered. How can I get the value instead of the ID to show on the report? I would like to keep the ID showing on the form and only have the value displayed on the report. Any help is appreciated.

 

[pbaldy]

It sounds like you want to want to base the report on a query that joins 2 tables together, enabling you to get the value associated with the ID.