Join Cris Ippolite for an in-depth discussion in this video Creating self-relationships, part of Relational Database Design with FileMaker Pro.
- View Offline
- We've been looking at various ways…to visualize and work with data from other related tables…in a properly-architected relational FileMaker database,…and in this movie, we're gonna discuss…how you can actually view related data…but from the same table that you're currently in.…So unlike other relationships where we focused…on putting a portal or a related field on a layout…and having to pay special attention to the context…of the layout as well as the context of the data…in the portal-related field, here we're going to put…a related field and a portal on a layout…where the layout and related field have the same context.…
Let's first create a story behind this exercise.…In this case, let's say we're going to put a field…on each customer record, right over here…by where it says "referred by", and in that field,…we're gonna store the ID of the customer…who referred the customer record that we're on.…So if such and such organization refers another customer…over to our company, then we're going to put the ID…of the referring account into that field.…
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