Tutorial

Making databases relational 57
3. Using the Field tool , drag a field onto the layout.
You see a Specify Fields 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, then click OK.
6. Repeat steps 3-5 for City and Country.
7. Move the fields if necessary, and make the fields large enough to
display all the data they contain. The fields should look like this:
8. 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.
View the new record in the related table
1. Go to the Data Entry layout, which is based on the Members table.
2. Go to the last record.
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