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!