Join Cris Ippolite for an in-depth discussion in this video Understanding problems caused by many-to-many relationships, part of FileMaker Pro: Relational Database Design (2011).
- Earlier in our discussion on identifying relationships…I mentioned that you could potentially identify…a Many to Many Relationship during your data modeling.…And that when you do,…you should resolve them by adding a Joint Table,…which we'll discuss in our next movie.…However, I'm frequently asked why Many to Many Relationships…need to be resolved at all?…After all, FileMaker lets you create them…and they appear to work, at least up to a point,…so I'm going to show you some examples…of where a many to many related structure would break down…inside of a real FileMaker database.…In the file that I've got here,…if you open it up you'll see…that we have two tables,…an Actor table and a Movie table.…
And in the Actor table, one record represents…any individual actor,…and we've got a unique ID set up as a primary key field.…In the Movie database,…one record represents one movie.…Same thing here, primary key field…to uniquely identify each movie.…So what type of relationship might we have…between these two tables?…So consider the statement,…
The course applies to versions of FileMaker Pro from 7 through the most current version.
- Reviewing relationships types
- Diagramming relationships
- Resolving many-to-many relationships
- Determining which tables need key fields
- Defining tables in FileMaker Pro
- Using the Relationship Graph
- Using multiple match fields in one relationship
- Using global fields to filter portals
- Creating self relationships
- Creating aggregate functions using relationships
Skill Level Intermediate
Q: The exercise files for this course do not work on a Mac. It downloads executable files. Can you provide a workaround?
A: The files provided for this course were made pre-FileMaker Pro 12. The system does not recognize the .fp7 files immediately as something that can be opened with FileMaker Pro 12 and instead shows them as Unix Executable Files.
The solution is quite simple. Just double-click the file, at which point the Mac will prompt you to choose an application to open the
file with. Select FileMaker Pro 12 and it will then convert the file from a .fp7 file into the new FileMaker Pro 12 file format, which is .fmp12.
Q: This course was updated on 5/12/2015. What changed?
A: We moved a video from the "Using Relationships" chapter of FileMaker Pro 13 Essential Training into this course, where it will remain evergreen.