Quick Start

76 Getting Started Guide
How does this happen? The Members file has a relationship to the
Companies file that is based on matching data in the Company field
in both files. The Company field is the match field. The Members file
displays the company address using related fields based on this
relationship.
You will learn both parts of this process: how to define the
relationship and how to display data using the relationship.
Exit or Quit FileMaker Pro to close both files before continuing.
Display a related record in a file
Define a relationship to another file
1. Open the Tutorial folder in the FileMaker Pro folder.
2. Open the Working Files folder.
3. Open the MyFiles10 folder.
You should be here:
FileMaker Pro\Tutorial\Working Files\MyFiles10.
MyMembers10.fp5 and MyCompanies10.fp5 are the same as the
sample files, but without the relational structures. You will build
these structures now.
4. Open MyMembers10.fp5.
5. Choose File menu > Define Relationships.
6. Click New, navigate to the MyFiles10 folder in the Working Files
folder, and double-click MyCompanies10.fp5.
7. In the Edit Relationship dialog box, select the Company field in the
left column, and the ::Company field in the right column.
Fields in the file you are working in (MyMembers10.fp5) are on the
left. Fields in the file you want to see data from
(MyCompanies10.fp5) are on the right.
8. Notice that the relationship name defaults to the name of the
related file: MyCompanies10.
9. Click OK, then click Done.
Display data from a related record
Once you’ve defined the relationship, set up the layout to display
data using that relationship. Here, you want to display the company
address.
1. In MyMembers10.fp5, choose View menu > Layout Mode.
2. Using the Field tool , drag a field onto the layout.
You see a list of fields in this file.
3. In the Specify Field dialog box, click Current File
(“MyMembers10.fp5”) and choose the MyCompanies10 relationship
from the list.
You now see a list of the fields in the related file
MyCompanies10.fp5. The colons (::) before each field name show
that these are related fields, not fields defined in the file you are
currently working in. These related fields will display data from the
related file.