Every database window has the same basic structure. Every database window has the same tools around the edges—what’s inside the window is up to you.Compare this window with the one shown in Figure 1-2.In cases where the number of related records for a given parent is large (a couple of thousand, for example), File Maker pops up a progress bar saying "Summarizing field: xxx" when my app accesses a different parent record with many related child records."Summarizing" can take 5 seconds for a couple of thousand child records when connected via a LAN, and much, much longer if connecting over the WAN.Also, I believe that Count() returns the number of values that are non- empty and valid (rather than unique) - at least that's what the documentation says Simple, elegant, and it works unbelievably well.
This is a classic problem with the summary functions that File Maker provides.
File Maker 13 introduced the List Of Summary function.
Soon after I put it to work we realized there’s a data display issue: the data was mismatched.
File Maker Pro databases can be as simple as a list of things you need to pack for a camping trip (complete with pictures) or as complex as a company-wide system for purchasing, sales, inventory, invoicing, shipping, and customer tracking. This chapter gives you a tour of File Maker’s major features and gets you ready to use your very first database.
File Maker’s vast assortment of tools and options can make the program’s window as intimidating as an Airbus cockpit.