Tutorial

82 FileMaker Pro Tutorial
Add the fields and format the portal
1. In the Add Fields to Portal dialog box, select the ::First Name field and move it to the Included fields list.
2. Select and move the ::Last Name field.
3. Click OK.
4. Click Inspector in the layout bar to open the Inspector, if it’s not already displayed.
5. Select Appearance and under Object, for Line choose the color Black.
6. Use the Text tool in the status toolbar to create field labels above the First Name and Last Name fields
in the portal.
The portal should look like this when you are done.
7. Click Save Layout, then click Exit Layout to view the list of members in each company.
Note Depending on experimentation you may have done in earlier lessons, your portal may look
different than the one shown in the following illustration.
8. Test your new structure: type the name of a new member at ABC Company, then switch to the Data Entry
layout to see if it appears as the last record in the database.
When you added the new member, the relationship automatically created a record for this member in the
Members table. ABC Company is automatically entered into the match field because the name was added
to the portal of the ABC Company record.
9. When you are finished with this lesson, close the file by choosing File menu > Close.
For more information
You have seen how to use and create simple relationships. This tutorial covers just the basics; there are many important
points to consider when building a relational database system. Be sure to read chapter 4 in the
FileMaker Pro User’s
Guide
and the relational information in FileMaker Pro Help before using relationships in your own files.
The portal displays a
list of members from
the related table
Click here to enter
a new member for
this company