Counting related records for a large data set

To add to this, I often have a calculated field in the child table that is an unstored calc that is simply Get ( FoundCount ). With that I can always see the count of records through that relationship, just by grabbing that value from the first related record. It seems that FileMaker doesn't even trigger a download of the entire record for it to work. So there is typically great performance.

4 Likes