• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Working with Multiple Tables > Creating a Many-to-Many Relationship

Creating a Many-to-Many Relationship

The preceding sections introduced you to most of FileMaker's fundamental tools for working with multiple related tables. Now it's time to extend those concepts and see how to use them to create a many-to-many relationship structure.

Building the Structure

Let's say that you've been asked to create a database for a town militia. You need to keep track of militia members in their own right, and you also need to be able to assign them to different guard shifts. An ERD for the proposed system is shown in Figure 6.17. On the one hand there are guard shifts, each of which can be staffed by several militia members. On the other hand, there are militia members, each of whom can work many shifts. This is a classic many-to-many relationship. You'll recall from Chapter 5 that such relationships are resolved with an intermediate join entity. In this case, we'll call the join entity a “shift assignment.” Each shift assignment records the posting of a single person to a single shift.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint