I need to attach two tables from two different data sources--an Oracle DB I have no control over, and an Access DB that I do. Here are the fields in each:

Oracle
Order #, Line #, Sell, Cost

Access
Order #, Line #, AdjSell, AdjCost

and I need to link the two so I can create a report with the line:

Order #, Line #, Sell, AdjSell, Cost, AdjCost

Seemed like a no brainer. I just linked the two together by Order# and Line#. Then I found out that while the combo of Order# & Line# makes the records unique in my table, it's not the case in the Oracle DB. That DB routinely has situations like this:

Order #, Line #, Sell, Cost
17789, 001, $100, 0
17789, 001, $0, $75

So I need the summary of those two:

17789, 001, $100, $75

to attach to my single line so I can add AdjSell and AdjCost to the end of it.

I could create an Access query to summarize the Oracle table and then report off of that, but it slows down the report in a big way. I was just wondering if there is a way to handle that kind of join in Crystal without doing the Access Query.

Hope that made sense. Thanks!