Page
|
|
|
Next Page |
|
| Contents > Working with related tables and files > About the types of relationships |
|
|
| About the types of relationships |
| When you join two tables using a relationship, you establish criteria that FileMaker Pro uses to display or access related records. |
| Your criteria can be simple, such as matching a field in Table A with a field in Table B. A more complex relationship definition will usually return a narrower set of related records. Examples of complex relationships include using multiple match fields, comparing match fields using non-equal relational operators, or using calculated match fields. |
| These are several common types of relationships, explained in the following topics: |
 |
About single-criteria relationships |
|
About multi-criteria relationships |
|
About relationships using comparative operators |
|
About relationships that return a range of records |
|
About self-joining relationships |
| Related topics |
|
About the relationships graph |
|
About match fields for relationships |
|
Creating relationships |
|
|
| Contents > Working with related tables and files > About the types of relationships |
|
|
Next Page |
|