I have reports that run showing work that needs to be completed. The query for this report contains a 'CustomerID', which is the Primary Key to a table with CustomerInfo. I cannot seem to figure out how to get the report to show the work information (The information the report always shows) but to also include the customer information, as is i can only get it to show the CustomerID, not the information it is linked to.
I have a feeling it is something easy that i am missing, but maybe not Thoughts?