• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Working with Multiple Tables > Multi-table Systems in FileMaker Pro

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint