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

Discussion created by l_allen_poole on Mar 29, 2016
Latest reply on May 10, 2016 by Benjamin Fehr

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.