FileMaker Pro 8 for Windows and Macintosh: Visual Quickstart Guide

Chapter 10. Creating Relational Databases

Creating relational databases is a multi-step process, which you begin by adding match fields (sometimes called key fields) to each set of source and destination files. The match fields enable you to take the second step of creating the relationship (or link), which simply acts as a pointer from the destination file to the source file. In the final step, you then define the relationship between the files by specifying what fields you actually want used in creating lookups and portals between them. Additionally, you can define relationships for specific layouts, which give your databases tremendous flexibility.

For example, in this chapter we create match fields in the source and destination files using ...