Chapter 6. Working with Multiple Tables

In this chapter

Multi-table Systems in FileMaker Pro 154

Creating a One-to-Many Relationship in FileMaker 154

Working with Keys and Match Fields 158

Understanding Table Context 161

Working with Related Data 162

Creating a Many-to-Many Relationship 168

Relational Integrity 173

Troubleshooting 175

FileMaker Extra: Building a Three-Way Join 176