A client wants to generate a summary report containing one line per Job.

Here's the file setup (using SBT-type files, but that's not important now):

PAPROJ - one entry per Job; contains Job Description info.
PAMAST - one entry per Job/Phase/Category; contains budget info for each
Job/Phase/Category.
PATRAN - (potentially) multiple entries per Job/Phase/Category; contains
transaction (actual cost) info.


The report output would be:
Job #, Description, Budget Total (from PAMAST, with multiple records per Job), and Actual Tran Total (from PATRAN, with multiple records per PAMAST record).

Optimally, someone could suggest a way for me to do this with FoxFire, but if the answer comes in the form of a query, I'd be just as appreciative.

TIA,
Mark