Pro-Form Quick Start 9.0 User's Guide download pdf (Page 70)

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

1 2 ... 65 66 67 68 69 70 71 72 73 74 75 ... 81 82

No comments

Pro-Form Quick Start 9.0 User's Guide Page 70