AnsweredAssumed Answered

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

Question asked by philmodjunk on Oct 14, 2010
Latest reply on Nov 24, 2010 by TSGal

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.

Outcomes