Filemaker Pro 10 TU689LL/A Benutzerhandbuch

68     FileMaker Pro Tutorial

5. Release the mouse button. You see the relationship you have created.

The relationship is based on matching data in the Company field in both tables. Records are related when 
data in the Company field in one table matches the data in the Company field in the other table.

6. Click OK to save this relationship.

Once you’ve defined the relationship, you can modify a layout to display data using that relationship. Here, 
you want to display the company address.

1. Choose Corporate Account Information from the Layout pop-up menu.

2. Click Edit Layout in the layout bar.

3. Using the Field tool   in the status toolbar, drag a field onto the layout.

You see the Specify Field dialog box displaying the list of fields in this table.

4. Click Current Table (“Members”) and choose the Companies table from the list.

You now see a list of the fields in the related table Companies. The colons (::) before each field name 
show that these are related fields, not fields defined in the Members table you are currently working in. 
These related fields will display data from the related table.

5. Click ::Company Address. 
6. Select Create label (if it’s not already selected), then click OK.
7. Repeat steps 3-6 for ::City and ::Country. 
8. Move the fields if necessary, and resize the fields to display all the data they contain. The fields should 

look like this:

9. Click Save Layout, then Exit Layout in the layout bar to return to Browse mode and click the book in the 

status toolbar to flip through the records to view company addresses from the Companies table in the 
Corporate Account Information layout that is based on the Members table.