The Separation Model – Part 6
FileMaker has a few unique features because of it being its own database. Unlike SQL, where you make selections across multiple tables (which FileMaker does support the use of some SQL - via a plugin), there's this concept of multi-keys for the purpose of relating many to many via one single record - or via one single field actually, it's known as a multi-key field.
Knowing about this unique feature, and using it when it makes sense, is something you can take advantage of. So, the trick is knowing the difference between when to use a multi-key relationship versus using an actual join table.
In this part of the series, I showcase how I interrelate a group of people into a grouped family. I do this without using a Join table because the situation is such that the records which relate together are pretty static. Once the relationship is made it's pretty much permanent. I also show you one of the most powerful custom functions you'll ever use when using FileMaker's multi-key feature. It's something you'll use often once you see how useful multi-keys can really be.
Comments
question: importing data
Great series! Perhaps you'll cover this later. But it would seem difficult to import data from a spreadsheet in this approach. Lots of projects involve migrating from a spreadsheet to a database, so this would seem to be important. thanks.
Thomas Keller, PhD
Research Data Services
Portland, OR 97239