Creating relationships
You create relationships between fields in tables to see and work with another table’s data.
After you have created a relationship, you can add or change match fields, change relational operators, and set options for creating, deleting, and sorting related records. See Changing relationships.
To create a relationship:
1.
Open the relationships graph for the database.
See Working with the relationships graph.
2.
They can appear anywhere on the graph, but they must be present on the graph in order to create the relationship. For self-joining relationships, locate the single table; FileMaker Pro will create the second table occurrence for you.
3.
You can also click Add relationship button and specify the relationship.
Note  For self-joining relationships, click a match field in the current table and drag outside of it, then back onto the second match field within the current table. Rename the new table occurrence, or click OK to accept the default name.
4.
5.
Related topics 
About the relationships graph
About the types of relationships
About match fields for relationships
Adding tables to the relationships graph
Defining database tables
Deleting table definitions, field definitions, and data