2 Replies Latest reply on Nov 24, 2010 2:35 PM by TSGal

    Finds on calculation fields computing values from global field based relationship fail

    philmodjunk

      Summary

      Finds on calculation fields computing values from global field based relationship fail

      Product

      FileMaker Server

      Version

      10, 11

      Operating system version

      Windows XP SP3

      Description of the issue

      While helping another Forum member, we created a simple test file with this relationship:
      Items::ProductCode = LineItems::ProductCode AND
      Items::gDate = LineItems::Date

      Items::gDate is a global field

      Host this file on FileMaker server and enter a date in gDate and specify > 0 or just an * in a calculation field defined in Items as Sum ( LineItems::Qty ) and FileMaker frequently fails to find the correct records in Items if the file is hosted on FileMaker Server. From a local copy of FileMaker the find works correctly.

      A sample file may be downladed from: http://www.4shared.com/file/0RMJUjNv/CalculatedDateTest2.html

      Steps to reproduce the problem

      See this thread for a detailed step by step description:  http://forums.filemaker.com/posts/58b3b37d8c

      Workaround

      Perform a find on the related table and use sub summary reports/summary fields to create a very similar report.