Chapter 6. Creating Relationships
Many databases start their lives as free-floating entities, managing a single table of data and unconnected to other files. But the time inevitably comes when you want more flexibility in how you view your information. Equally likely, you'll find that some information in one database could be profitably used in another.Perhaps you're one of those organized people who have planned out all the possible connections your files could make and have built them to share data. Hats off to you if you have! In reality, such clarity usually comes with experience. Most likely, you're working with databases that were created before you discovered all the ways they might interconnect.FileMaker doesn't require you to own a crystal ball. In fact, a database file that's too full of fields becomes cumbersome to update and takes too long to search. By creating tables, and then creating relationships between them, you can painlessly join and manipulate multiple sets of data without having to duplicate information.In FileMaker Pro 7, you can create relationships between tables within a single file or between separate files, as was the case in earlier versions. There are advantages to both methods. See Chapter 15, "Migrating to Version 7" for details on these advantages and disadvantages and how they apply to upgrading to version 7.