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.
In the relationships graph, locate the two tables you will be using for this relationship.
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.
Click a match field in one of the tables and drag to the corresponding match field in the other table.
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.
Repeat step 3 for each match field you intend to use in this relationship.
5.
Click OK.
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
Was this topic helpful? Send feedback.