6. Working with Multiple Tables
Multitable Systems in FileMaker Pro
This chapter shows you how to take the ideas from Chapter 5, “Relational Database Design,” and use them to build FileMaker database systems. You learn how to use FileMaker to create database systems that model the types of relationships covered in the preceding chapter.
Chapter 5 laid out a set of design concepts that centered around the ideas of entities, their attributes, and the relationships between entities. In FileMaker Pro, you generally represent a database entity (“student,” for example) as a table. You generally represent an entity’s attributes (“first name,” “year of graduation,” for example) by the fields of that table. And you create relationships among tables with ...