AnsweredAssumed Answered

calculations on related records

Question asked by wngiii on Nov 12, 2009
Latest reply on Nov 12, 2009 by philmodjunk

Title

calculations on related records

Post

Greetings, 

 

I'm working with the trial version of Filemaker Pro 10.  Is there is a calculation to find the most restricted value in a list of related records.  For example.  I have an album with 10 tracks on it.  each track is linked to an artist contract which gives us specific right to sell the album in a territory. For example

 

Track 1 is World Wide

Track 2 is World Wide

Track 3 is World Wide

Track 4 is World Wide

Track 5, 6, 7, 8 & 9 are World Wide

....

Track 10 is US & Canada only

 

since that one track restricts the entire albums rights I would like it to automatically default to the most restricted (in this example US & CA).

 

I've though some sort of value map based on the Territories but don't know if that can be done in FMP 10

 

Thanks for any help!

Bill 

 

 

 

Outcomes