AnsweredAssumed Answered

Conditional Calculations across related Databases

Question asked by deedeetee on Oct 3, 2016
Latest reply on Oct 3, 2016 by deedeetee



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!