5 Replies Latest reply on May 10, 2016 10:23 AM by Benjamin Fehr

    Un-stored calculation field behaves as global field in some new ways

    l_allen_poole

      Product and version: FMA 12, 13, 14...

      OS and version: MacOS 10.11

      Hardware: Core i7 MacBook Pro


      Description: Calc. field with indexing turned off is evaluated even when there are no records in the table, and also when referenced in a calc. in a related table even when there is no related record there. Layout display is idiosyncratic, depending on whether field is placed in a portal or not.


      How to replicate: See attached sample file, showing 1 record in table 1 that has a related record in table B and one record in table A that has no related record in table B. For additional fun, delete the record in table B and observe continued odd behavior.


      Workaround (if any): Use FileMaker version 11 or earlier! This behavior was new in .fmp12.