FileMaker Pro 9: The Missing Manual

Chapter 7. Multiple Tables and Relationships

Up until now, you’ve been working with the simplest kind of database imaginable—it has just one table. In the real world, one table is almost never enough. In your private investigator business, for example, you probably need to keep track of more than just people. You need to record the time you spend working for your customers, the invoices you send them, and the payments you receive.

You can certainly create a separate database for each of these needs. But that’s far from ideal, since you don’t use each kind of information in isolation. You need all these different kinds of information to work in harmony, like a well-rehearsed orchestra. In database terms, what you need is a single, integrated file that keeps all your various lists, files, and records in one place, so you can arrange and rearrange them according to your needs—a relational database.