Hello, I am newbie to this forum but not to FM. I am trying to improve a database I "inherited". When I try to find based on data in an aggregate calculation field, the find is returning all records in the table.

Table A - Buildings (7000 records) related to

Table B - Spaces (6000 records)

Table B includes a number field called Size which is the square feet of the space.

When in table A, I can find by size directly in a portal to table B. But I need to find by aggregated data from Table B, specifically a Sum() calculation. When I enter valid find criteria in the aggregated field, the find returns all records in Table A.

I created a new test database with just a few records to simulate the problem, and the find works perfectly there.

Does FM just reject a find when there are too many related records involved?

Also, I am about to upgrade to FM 11. Will this improve this behavior?

Grateful for any wisdom. Thank you.

I created a new test database with just a few records to simulate the problem, and the find works perfectly there.

Why don't you import all your records into the test file and see what happens.

Good idea. I imported all the records into the test database, and aggregate finds are working there.

However, the finds still do not work in the original db. The original db is hosted by FM Server. I made a copy of the original db and opened it on my workstation. The aggregate finds are working there as well. So it appears there is some issue with the finds being disabled by FM Server. Any knowledge of that?

Did you apply all the latest patches?