Quick Start

78 Getting Started Guide
View the new record in the related file
1. Open Members10.fp5.
2. In Members10.fp5, go to the last record.
You see Joe Williams’ record, with the company information filled
in. You automatically created this record when you typed Joe
Williams into the list in the Companies file.
Add a new record and view it in the list
1. In Members10.fp5, create a record for a new member who works
at ABC Company.
2. Now return to Companies10.fp5 and look at the ABC Company record.
You see the new member in the list (scroll down if necessary).
About working with lists of related records
In the “View data from one related record” on page 75, a relationship
in the Members file displays data (company addresses) from the
Companies file. Here, a relationship in the Companies file displays
data (member names) from the Members file.
Both relationships use the same match field, Company, but this time,
there is more than one matching record in the related file because
there is more than one member from each company. A portal in the
Companies file displays the members for each company.
When you added Joe Williams to the list of members who work at
ABC Company, the relationship automatically created a record for
Joe Williams in the Members file. ABC Company is automatically
entered into the match field because the name was added to the portal
of the ABC Company record.
A new member added to the Members file automatically appears at
the end of the members list in the matching company record in the
Companies file.
Exit or Quit FileMaker Pro to close all open files.
Display a list of related records
Create a portal to display matching records
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.
4. Open MyCompanies10.fp5.
A relationship must always be defined before you can display data
from related records. The relationship to MyMembers10.fp5 has
already been defined for you, using the process described in “Define
a relationship to another file” on page 76.
5. To view the relationship, choose File menu > Define Relationships,
select the relationship (MyMembers10), and click Edit.
6. Notice that Allow creation of related records is selected. This lets
you add a name to the list.
7. Click OK, then click Done.
8. Choose View menu > Layout Mode.
9. Click the portal tool and draw a box to hold the list of names
.
10. In the Portal Setup dialog box, show records from the
MyMembers10 relationship.
11. Show 7 rows in the portal.
Each row displays one matching member record.
12. Select Show vertical scroll bar.
13. Click OK.