From the course: FileMaker: Relational Database Design
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Understanding problems caused by many-to-many relationships - FileMaker Pro Tutorial
From the course: FileMaker: Relational Database Design
Understanding problems caused by many-to-many relationships
- [Instructor] Earlier in our discussion on identifying relationships, I mentioned that you can potentially identify something called a many to many relationship during your modeling exercises, and that when you do you should resolve that with a join table, which we're going to discuss in the next movie. Many to many means that you actually have two parent tables, but their relationship is not actually direct, and instead would need to be related through an additional child table that would be common to both tables. Again, more on that in the next movie. I'm frequently asked why many to many relationships need to be resolved. After all, FileMaker lets you create them, and they can work to some degree or at lease appear that they're working. I'm going to show you a couple of quick examples of where the structure would break down in a real FileMaker database once you actually try to use it. I've got an exercise file here. We've got two tables in it. We've got actors and movies. The…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.