Special Edition Using FileMaker 8

Chapter 6. Working with Multiple Tables

In this chapter

• Multitable Systems in FileMaker Pro 158

• Creating a One-to-Many Relationship in FileMaker 158

• Working with Keys and Match Fields 162

• Understanding Table Context 164

• Working with Related Data 166

• Creating a Many-to-Many Relationship 172

• Relational Integrity 177

• Rapid Multitable Development 179

• Troubleshooting 180

• FileMaker Extra: Building a Three-Way Join 180

Multitable 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 ideas and use them to build FileMaker database systems. You’ll learn how to use FileMaker to create database systems that model the types of relationships covered in Chapter 5