Help

Working with related tables and files
F
ILEMAKER PRO HELP 384
About relationships using comparative operators
About self-joining relationships
About self-joining relationships
A self-join is a relationship in which both match fields are defined in the same table. Define a self-
join to create relationships between records in the same table. Use a self-join in a portal on a layout
of the current table to display a subset of data that's in the current table, such as all the employees
of each manager.
When you define a self-joining relationship in the relationships graph, FileMaker Pro generates a
second occurrence of the table upon which you are basing the self-join. FileMaker
Pro does this to
prevent the relationships from forming a cycle, which would make it impossible to evaluate.
A self-joining relationship looks like this:
This relationship returns related records in TableG when the value in TextFieldG1 is the same as the
value in TextFieldG2.
Related topics
About single-criteria relationships
About multi-criteria relationships
About relationships using comparative operators
About relationships that return a range of records
Working with the relationships graph
Use the relationships graph to create, change, and view the relationships in your database file.
By default, the relationships graph displays all of the tables in your current database file. You can
add tables from other files (including external ODBC data sources), add more than one occurrence
of the same table to the graph, or remove tables from the graph using the buttons described below.
You can use the undo and redo keyboard shortcuts to incrementally remove or replace changes in
the relationships graph. To undo changes, press Ctrl+Z (Windows) or Command-Z (OS X). To redo
changes, press Ctrl+Shift+Z (Windows) or Command-Shift-Z (OS X).
To access the relationships graph:
1. With the database open, choose File menu > Manage > Database.
2. In the Manage Database dialog box, click the Relationships tab.
The relationships graph appears.