AnsweredAssumed Answered

Keeping Score via Relationships

Question asked by Jason_Farnsworth on Feb 27, 2015
Latest reply on Mar 2, 2015 by Jason_Farnsworth

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.

 

Jason Farnsworth

Outcomes