When FileMaker sorts records it happens on the client machine. Consequently, sorting can be a very painful process for users over a slow connection to a database. In this article we show a very fast way in which records can be presented to the user in descending creation order, without sorting delays... Read more...
Building layouts in FileMaker can involve adding a number of various elements such as fields, buttons, portals, tab controls, and graphics such as jpg and png images. It is the use of images on layouts that this article is all about. Read more...
With the introduction of script triggers in FileMaker 10, live filtering or portals was made possible. Numerous techniques were introduced to help achieve this. In conjunction with existing filtering techniques, the "Live" aspect was achieved usually by introducing an OnObjectModify script trigger to the filter entry field. As soon as the user enters a value into the field, the triggered script would force a save of the fields contents, thus updating the relationship in question, which in turn updated results in a portal on screen… 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...