Jeremy Brown gives a nice overview of how to relate many-to-many tables, using a join table. It’s a concept that is used in just about every relational database model. A concept that is important for beginners to grasp. Once you get this basic concept, you can create complex relationships to make your data more useful. Jeremy shows us how to connect the tables in the FileMaker Relationship Graph, and to display the related data in your layouts using portals to view those relationships.
Knowing how to use a FileMaker Join table ( though not exclusive to FileMaker) can solve many data-model related questions for us. … The join table, as it is commonly called and known, solves the complex problem of how to structure the data model when the entities are related in a many-to-many style. A classic example of these entities includes classes and people. Many people have many classes. A join table joins these two entities together.