I need to make a calculation based on (2) separate relationships
What I have....
Table-Customer (1) ==> Table-Jobs (Several) ==> Table-Inspections (Several) ==> Fields (7) that score an inspection item, the score will be from 1-5.
What I want...
I would like to analyze the composite of all of one customers - Jobs & Inspections to get a total score of the the inspection item.
So for example...
(1) Customer - (2) Jobs - (3) Inspections per job == totaling for this (1) customer (6) Inspections per Item creating a total score from 6-30 for that Item keeping in mind I have (6) other items also to score.
Is it possible to calculate this score dynamically via the relationship? I know that I can script the result but was looking for a way to keep it dynamic as possible as I have several customers with thousands of inspections.
Thanks in advance, let me know if I need to provide more information for a cleaner view of the issue.