Quick Start

Making databases relational 83
4. Click ::Company Address, then click OK.
5. Repeat steps 2-4 for City and Country.
6. Move the fields if necessary, and make the fields large enough to
display all the data they contain. The fields should look like this:
7. Choose View menu > Browse Mode and flip through the records to
view company addresses from the MyCompanies file in the
MyMembers file.
8. When you are finished, Exit or Quit FileMaker Pro to close all
files before continuing.
View data from a list of related records
Suppose you want to show all club members for each company. You
also want to add new members to the Members file without entering
the company name for each.
Work with related records in the sample files
View a list of related records
1. Open the Tutorial folder in the FileMaker Pro folder.
2. Open the Sample Files folder.
3. Open the Sample10 folder.
You should be here:
FileMaker Pro\Tutorial\Sample Files\Sample10.
4. Open Companies10.fp5.
5. Browse through the records.
You see a list of members at each company. They are all individuals
in the Members file.
Add to the list
1. Go to the ABC Company record.
2. Add a new member by clicking the first empty line under First Name.
3. Type Joe, then press Tab and type Williams in the last name
field.
Choose the relationship
to display fields from the
related file
Displays a list of
members from th
e
related file
Click here to enter
a new member for
this company