Multi-table Systems in FileMaker Pro

Chapter 5, "Relational Database Design," laid a heavy dose of abstract database theory on you. This chapter shows you how to take those essential ideas and use them to build more complex FileMaker database systems. You'll learn how to use FileMaker to create database systems that model the types of relationships covered in Chapter 5. In general, we don't like to prescribe a linear path through this book, but for this chapter (and really the one following, as well), we're going to assume you've either read Chapter 5 already, or have a reasonable familiarity with the terms and concepts of relational database design. If terms such as entity-relationship diagram, primary key, foreign key , and one-to-many relationship are unfamiliar to you, we recommend you review Chapter 5 before proceeding here.

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'll generally represent a database entity ("student," for example) as a table . You'll generally represent an entity's attributes ("first name ," "year of graduation," for example) by the fields of that table. And you'll create relationships among tables with FileMaker's Relationships Graph, a new tool that we'll be showing you in this chapter.

Before you get into the meat of this chapter, it's a good idea to review FileMaker's default behavior when you create a new database. When you create a new database, FileMaker creates a database with just one table in it, and that table initially has the same name as the name you gave the database as a whole. This is a sensible default behavior if you only ever intend to work with one table in the given database.

But FileMaker also has facilities for adding more tables to a system, adding different fields to each table, and creating many kinds of relationships between tables. We explore these tools in the context of some of the fundamental relationship types discussed in Chapter 5.