OK Ill explain this as best as I can

I have two tables - I buy widgets in the hundreds but they are different sorts. I sell widgets of the same kind in different numbers and kinds.

I want a purchases and sales report all in one

i.e

Code:
purchaseName  PurchaseNo  PurchasePrice  SaleName  SaleNo  SalePrice
Widget1           100          100       Widget1     100      200
...