Join Cris Ippolite for an in-depth discussion in this video Using relationship options to create related fields, part of FileMaker Pro: Relational Database Design (2011).
- Up until this point, we've been looking…at how to use the FileMaker relationship graph…to set up your database's basic one-to-many relationships.…That relationship graph can be found under file,…manage, and database, and it's the last tab on the right.…Relationships can have different options set up for each,…besides just which key fields are used in the match tables.…So you see now we've just simply selected what the…primary key and the foreign key are…gonna be in each relationship,…but if you'll notice, there's a little equals sign…in the middle of the line in between each tables…in a relationship and if you click on that equals sign,…you'll see the edit relationship dialogue appear.…
This dialogue lets us control all…of the options for a relationship.…You'll notice that each table in the relationship…is represented here, one table on the left,…in this case, the parent, and then another table…on the right, so this is where you can select all the…different fields that you would use as your match fields.…
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.