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