Organization & Groups

We wish that FileMaker would have groups in other places similar to script groups. But because it does not, you’ll find that we try to create groups of things in various places like custom functions, value lists, layouts, etc.

In define database dialog, you’ll also see groups. In some tables there are more groups than in for other tables. This picture is a great example of the 4 groups that we normally have all of our tables. At the very top we keep all the IDs together (primary and foreign). Then comes a list of fields used for meta data ­– such things as by whom and when the record was created or modified. We then include a group of fields for the actual data that we will be interacting with. Lastly, the grouping at the bottom contains the list of calculation fields.