Database Reference
In-Depth Information
The problem is solved with a
portal
, which is a layout object that displays multiple records
from a related table. Not only can the portal display related records, but you can also use a
portal to create, edit, and delete related records.
Adding a Portal to a Layout
A portal can display as many related records as you want, limited primarily by the size of
your layout and the height of the portal. As with other layout objects, you can format portals
to match your database, using fills and lines the way you would with other drawn objects.
Here's how to create a portal on the Lease Agreement layout:
1.
In Layout mode, drag the bottom edge of your Body part to make room for your
portal. Or use the Inspector to make the Body 500 points high
.
Figure 4-10
shows you how much space you'll need.
Figure 4-10. In the upper right of the Status toolbar, you see the Portal tool selected. On
the layout you can see an outline where the portal will be when you finish creating it. The
settings shown in the Portal Setup dialog box above, along with the relationship's setting to
allow record creation, let you create, edit, and delete Payment records without ever having
to visit a Payment layout.
2.
Click the Portal tool to select it and then drag on the layout to create a portal
.
As with all drawn objects, it's usually easiest to start in the upper-left corner and drag
to the lower-right corner where you want the portal to appear. When you release the
mouse, the Portal Setup window appears.
