AnsweredAssumed Answered

calculations on related records

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


calculations on related records




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!