Report ???'s

[beckie1234]

I have a form that stores data in a table. When it stores data it is using the primary key as the source to save space. When I write a query for a report using this data I want it to show the value of the primary key and not the pk value. Does that make sense?? Any suggestions??

 

[boblarson]

What you need to do is to use a query for the report's recordsource instead of just the table and the query would include the other table that has the actual text value.

 

[beckie1234]

Thanks works great. Produces exactly what I am looking for. I knew it was something simple.