Does anyone know how to combine the Timberline PO Data with your own Timberline data? I have written a report in Crystal that pulls the PO data ok and allows me to pull in the Job master file because I can combine the Timberline Office PO Data but I cannot pull in the our normal data fields. The report prints blank when I try. I have tried a sub report, different linking methods as well as SQL with UNION ALL but none worked either. I am assuming because the databases are different the UNION ALL does apply like it does when combining NEW,CURRENT, HISTORY files.

I have the PO#, Supplier Name, Job, Job Description, AR Customer #, PO line amount, and PO description but I need to add the AR customer name. Unfortunately, the Timberline Office PO Data only has the master files of AP, EQ, GL, JC not AR to pull from.  

Currently, I am dumping into Excel each morning and using the Office Connector Lookup Function on the AR# to pull in the customer name. I would appreciate any help or suggestions.