Tutorial

Lesson 10
Making databases relational
Relational databases let you easily view related data and streamline
data entry. You can enter data once, then view and use that data in
related tables or files.
In this lesson, you will:
1 see how relational databases work
1 define a relationship
1 display data from one related record
1 display a list of related records
The sample file in this lesson uses two tables:
1 a Members table with records for individual Corporate Travelers
Club members
1 a Companies table for companies where these members work.
Each company has many members.
Important Copy the Tutorial folder to your hard drive or verify that
it is installed before beginning this lesson. See
“Where to find the
lesson files” on page 7 for more information.
View data from one related record
See how relationships work in the sample files
1. Open the Tutorial folder on your hard drive.
2. Open the Sample Files folder.
3. Open Sample10.fp7.
4. Choose the Companies layout from Layout pop-up menu, and
browse through the records.
The Companies layout is based on the Companies table, and shows
records from that table. The Companies table has three records, one
record for each of the three companies that has members in the
Corporate Travelers Club. Each company record also contains a
portal that displays the club members from that company.
5. Choose the Corporate Account Information layout from the
Layout pop-up menu.
Corporate Account Information is based on the Members table, and
shows the company information for each of the 30 members in the
database.
6. In Corporate Account Information, create a new record for Jane
Doe
.
7. For Company, click the Company field and choose ABC Company.
8. Notice that the address for ABC Company automatically appears.