Calculating a related Total

[ollieluff]

I am in the process of writing a database to keep track of my self-employment work. I currently have a portal inside my company record layout and wish to calculate the total money earnt from that company based on the records from my job table. I assign each job a related fk_company_id but can't work out how to get the calculation function to only calculate that company not the entire database.

Any suggestions really gratefully received...

[bcooney]

Create a calc in Companies, sum (Company_to_Jobs_by_CompanyID::Billed). You will be using the relationship to narrow the records summed to just those that correspond to the parent company record.

From another angle, you could create a sub-summary report of Jobs. Create a summary field in Jobs, Total of Billed, in a sub-summary part by Company and sort by Company.