Tutorial

Lesson 11 | Making databases relational 70
7. Click Edit Layout in the layout bar.
8. Select the Portal tool in the status toolbar and draw a box on the layout to hold the list of
names.
9. In the Portal Setup dialog box, for Show related records from choose the Customers table.
10. Select Show vertical scroll bar.
11. For Number of rows, enter 4.
12. Click OK.
Add the fields and format the portal
1. In the Add Fields to Portal dialog box, select the ::First Name field and move it to the Included
fields list.
2. Select and move the ::Last Name field.
3. Click OK.
4. Use the Text tool in the status toolbar to create field labels above the First Name and Last
Name fields in the portal.
When you are finished, the portal should look like this:
5. Click Save Layout, then click Exit Layout to view the list of customers in each company.
Note Depending on experimentation you may have done in earlier lessons, your portal may
look different than the one shown in the following illustration.
The portal displays a
list of customers from
the related table