Not sure if this is the right area, if not I apologize up front.
I have a report that was created and linked to a sql DB and table. Our end user wants to add a field from another table into the report. Let's say this is an invoice. So the form is already linked to the Invoice table. Inside there are 3 keys, and 3 paramenters that must be set (ship to, bill to, product key are the data fields - the 3 paramenters are date or date range, company and branch.
The field to be added is a tracking number from a shipping table. The only key in this table that matches is bill to.
Tell me, is there a way to tell me how to add a field in this report?
-Thanks in avance.
IP Logged
