Join Cris Ippolite for an in-depth discussion in this video Introducing the Relationship Graph, part of FileMaker Pro: Relational Database Design (2011).
- At this point in the process of creating…a related database in FileMaker,…we're assuming that you've already gone…through the data modeling exercise,…got your tables determined and defined,…and also gone into your database and defined…all of your primary and foreign key fields.…If you open up your exercise files,…you'll see that we've got a file called 04_03.…Opening up 04_03…and going into the Manage Database option,…and you'll see that we've got our four tables defined,…and double-clicking each table…shows different fields that are defined.…
You can also use the drop-down list to show…those field names.…And you see that we've all of our primary keys…and our foreign keys defined within our table.…Now you'll notice that there's another tab…on the far right here, and that one is called Relationships.…Go ahead and click on the Relationships tab,…and what you're seeing here is your first glimpse…of what's called the relationship graph.…And inside this relationship graph…is where we can establish the relationships…
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.