Join Cris Ippolite for an in-depth discussion in this video Adding a join table, part of FileMaker Pro: Relational Database Design (2011).
- We have discussed the potential problems…with leaving a many to many relationship…in your database solution.…Again, FileMaker allows many to many relationships,…so why do we wanna avoid them?…To review, the issues that we mentioned…in the actor in movie's many to many relationship were,…that we wanted to create a report that list all the actors,…their roles, salary, and total salary…for all the roles they've ever played,…but we didn't have a context or table…to be able to based that off of.…And also, we ran into issues with storing character names…and salaries for each role because again,…no table exists for a role.…
Then also, how do we manage…actors working in different numbers of movies?…One actor might be working on 10 movies…and another working on five,…and then those lists can constantly grow,…so if we define a field…for each one of those roles for the actors,…we would never know how many different fields we would need.…We also discussed the searching issues…that we run into in our database.…How would we find an actor that played a certain role…
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.