FileMaker Pro, beyond your normal join table, offers a unique method of storing collections, or groups, of items. You can do this with what is called a multi-key field. This isn’t to be confused with a compound-key, which is a primary key composed of multiple different values.

Using a multi-key field we can store a collection of custom functions within our Custom Function database. This makes it possible to start the process of collecting groups of functions together and then adding a feature so we can copy them as a group.

Of course, the trick to adding any complex functionality is to make it easy for the user while staying maintainable for us as the developers. This will be done within a standard FileMaker Popover layout object.

This video walks through the process and parts of adding a grouping or collections based feature. While we’re adding it within the context of custom functions, this is a feature you’ll find using over and over again no matter what the database is about.

Click the title or link to this article to view the video.

View the full article