Tutorial

Making databases relational 57
3. Using the Field tool , 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, then click OK.
7. Repeat steps 3-6 for ::City and ::Country.
8. Move the fields if necessary, and make the fields large enough
to display all the data they contain. The fields should look like this:
9. Choose View menu > Browse Mode and 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.
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 table without
entering the company name for each.
Work with related records in the sample file
View a list of related records
1. Choose Window menu > Sample10.
2. Choose the Companies layout from the Layout pop-up menu.
3. Browse through the records.
You see a list of members at each company. They are all individuals
in the Members table.
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 table from
the table pop-up
menu
Displays a list of
members from
the related table
Click here to enter
a new member
for this company