Finds on calculation fields computing values from global field based relationship fail
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
Perform a find on the related table and use sub summary reports/summary fields to create a very similar report.