3 Replies Latest reply on Oct 3, 2016 11:35 PM by deedeetee

    Conditional Calculations across related Databases

    deedeetee

      Hello,

       

      I'm still trying to learn Filemaker... I have a database that lists episodes of a tv show, and this is related to another database that has the relevant dates for episodes (rehearsal, recording, broadcast, repeat, etc...) However, for the Episode database, I want to have a field which reflects the Broadcast date. I've tried creating a conditional calculation to create this ( if( dates:datetype = "Broadcast" ; Dates:Date; "") ), which works well, but the conditional calculation seems to only look at the first related Date record created, rather than search through all the related Date records and finding the one that shows Broadcast, to return the correct date.

       

      Hopefully that makes sense, and even more hopefully, someone may have an answer!