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

Chapter 6. Working with Multiple Tables > FileMaker Extra: Building a Three-Way...

FileMaker Extra: Building a Three-Way Join

In the “Extra” section at the end of Chapter 5, we sketched out the ERD for a many-to-many-to-many relationship among truckers, trucks, and truck routes. We follow up on that discussion here and show you how you might build such a thing in FileMaker.

Structurally, it's not too complex—we already worked out the relationships at the end of Chapter 5. You need a four-entity system: Trucker, Truck, Route, and the central three-way join entity, called in this case RouteAssignment. The Relationships Graph for such a structure might look like Figure 6.24.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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