Chapter 7. Working with Relationships

In this chapter

Relationships Graphs and ERDs

Relationships as Queries

Creating Self-Relationships

Creating a Relationship with a Global Value

Creating Cross-Product Relationships

Working with Multiple Files

How and When to Use Multiple Files

Troubleshooting

FileMaker Extra: Managing the Relationships Graph

Relationships Graphs and ERDs

Chapter 5, “Relational Database Design,” outlined some database theory that helps produce an ERD—an entity-relationship diagram that shows the fundamental building blocks of a database system and the ways in which they relate. In Chapter 6, “Working with Multiple Tables,” we showed how to use FileMaker’s relationship tools to turn an ERD into a working FileMaker database. ...

Get Special Edition Using FileMaker 9 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.