Crystal 7 - Linking Sales Order # from 2 sources

[stoopers]

Using Crystal 7.0 & Scala 5.0. I am combining revenue & cost data into 1 report. I need to combine the details by sales order # and use the customer code from the revenue source. Unfortunately, the data tables are not linked by sales order#.


Customer Code SO# ACCT Rev$$ COS
GUL01 8268 1210 500.00
TIRRUNIT 8268 3000 1500.00

The final line of data should be:
TIRRUNIT 8268 1500.00 500.00

How can I accomplish this?

 

[synapsevampire]

Rather than stating how they are not linked, perhaps you should state how they are?

I'd guess that you link by whatever you can, then group by the sales order, and do whatever summaries you need. Stating that you need to combine the details by sales order isn't very descriptive.

In general try posting:

Example data (show fields/tables involved and soem data)
Expected output (what the above would then produce)

-k