User manual

144 | Working with related tables and files
For example:
Another example:
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 is 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 graph from
forming a cycle, which would make it impossible to evaluate the relationship.
This relationship returns related records in Table G when the value in Text
Field G1 is the same as the value in Text Field G2.
For more information about the types of relationships, see Help.
If fields Contain values
These related records are returned
from Table F
Starting Date E 11/01/2010 11/14/2010
11/27/2010
Ending Date E 12/01/2010
If fields Contain values
These related records are returned
from Table F
Starting Date E 12/01/2010 12/02/2010
12/15/2010
12/17/2010
12/26/2010
Ending Date E 01/01/2011
Self-joining relationship
Match field
Match field
φμπ10_υσερσ_γυιδε.βοοκ Παγε 144 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ