Join Cris Ippolite for an in-depth discussion in this video Using portals to connect to data more than one table away, part of FileMaker Pro: Relational Database Design (2011).
- Thus far in our examples, we've worked…with showing child records in a portal…in the context of a parent.…For example, if you look onscreen,…we're looking at a layout that's based on…the Customer table.…And what we've got here on the bottom…are two portals that are showing related order records.…So the Customer table is the parent table…in this relationship, and the Order table…is the child table.…A lotta people like to call this…looking at related records from one table away.…But when we were discussing the concept…of diagramming your relationships,…I mentioned how parent tables are not…only related to the child tables,…but are also related to all linked tables…through a chain of relationships.…
And if we go under the File, Manage, Database…and the Relationships tab, I can show you…visually how this works.…So we already know that…the Customers table and the Orders table…are related to each other, so, of course,…I can view all my related order records in a portal.…But let's say in the context of a Customer table,…
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.