FULL JOIN

Sure,

Table Estimates has fields Product, Estimate Amount, Category (look up field from Category table)
Table Purchase Orders has fields Product, PO Amount, Category (look up field from Category table)
Table Categories has a field Category, and it is a Parent table for Estimates and Purchase Orders tables.

I would like to have the Summary reports and the Chart reports, which will combine data from two and more tables, like

Category 1  | sum of Estimate Amount  |  sum of PO Amount
Category 2 | sum of Estimate Amount  |  sum of PO Amount
.....
Category n | sum of Estimate Amount  | sum of PO Amount

------------------------------
Andrew S
------------------------------