Join Cris Ippolite for an in-depth discussion in this video Using multiple match fields in one relationship, part of Relational Database Design with FileMaker Pro.
- Once you have your main FileMaker…table relationships in place,…you'll have the architecture you need…to build upon for your database.…Now I'd like to discuss with you…how you can also use the FileMaker…Relationship Graph to create other…query types of relationships that can be used…for specialized purposes.…Let's take a look at the Relationship Graph…under File, Manage, Database,…go into the third tab for Relationships.…The first thing I want to point out…is that the boxes that you place…on the Relationship Graph are not…actually tables although they do look like them,…rather they're known as table occurrences,…sometimes also referred to as TOs.…
A table occurrence is exactly that.…It's an occurrence or an instance…of a database table in a Relationship Graph.…Each table occurrence has a window…or point of view into the underlying source table…and therefore refers to only one…single underlying resource table.…So each box that you seen on screen…references one of the tables…in your database and only one.…However, one of the more powerful features…
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.