In the final part of this two part series, we cover the technique introduced in part one in more detail. We also carry out a number of tests and present the results. We also try to address some of the limitations of this technique and ways in which you could try to work around these… Read more...
In the first of a two part series, we begin the search for a faster way to perform aggregates in FileMaker. We cover why aggregates can be quite a costly operation - especially on wide area networks - and use that as a jumping off point for finding a faster method… Read more...
Recently on the Cafe Forum, someone asked if it was possible on a sub-summary report, to display the percentage of records contained within that sub summary part. Having never needed this functionality before, I decided to investigate how this might be done. What I came up with is a fairly simple and straightforward way to implement this. Read more...
The count function allows you to produce a count of the number of records through a relationship. However what may be less clear is that in order to achieve this, every record must be downloaded to the client computer, making the process very slow over a wide area connection. There is, however, an alternative to count in this situation which is almost instantaneous, this article explains how... Read more...