Auto-Enter calculation woes
I am bewildered...
I have 2 associated tables in a "one to many" relationship; CONTACTS and DOCUMENTS. I am trying to auto-enter a field in CONTACTS called "ConsentForm", with a "Yes" if any related document titles contain the string "consent".
To do this I've used the following calculation in the auto-enter calculation area for field ConsentForm:
Case ( PatternCount( List(cntct_DOCS::Title) ; "consent") ; "Yes" ; "")
For whatever reason the field ConsentForm refuses to have a "Yes" auto-entered. I've sanity checked my calculation by pasting it as the tooltip for ConsentForm and alas I get a "Yes", however nothing I seem to do will populate the actual field. I made sure the layout is referencing the same Occurrence as the auto-calculation. I even tried unchecking "Do not replace existing values" with no luck. What am I missing?
client machine: Filemaker Pro Advanced 13.0v3 (Mac)
accessing tables of a database on Filemaker Pro Server 13 (Windows)