Datasheet

Book IX
Chapter 1
Building Master and
Detail Pages
Developing Master and Detail Pages Block by Block
695
2. In the Document window, place the insertion point where you want
the records to appear on the page.
3. Choose InsertData ObjectsDynamic DataDynamic Table.
The Dynamic Table dialog box opens, as shown in Figure 1-5.
Figure 1-5:
The
Dynamic
Table dialog
box.
4. From the Recordset drop-down list, select the name of the recordset
that you want to appear on the master page.
5. Specify the number of records that you want to show at one time on
the master page.
In the example, we wanted to show 10 records at a time.
6. Optionally, specify border, cell padding, and cell spacing.
7. Click OK to close the dialog box.
The master table is created and added to your document.
If you don’t want users to see some of the columns on the master page,
delete the column from the table by following these steps:
1. In Design view, click anywhere on the master page.
2. Put the pointer near the top of the column so that the column’s entries
are outlined in red. Then click to select the column.
3. Click the Delete button to delete the column from the table.
Setting up links to open a detail page
After you create the master page (as the preceding section describes), you
need to create links that open the detail page and communicate which
record the user selected so that only the detail for that record displays.
To set up links to open a detail page, follow these steps:
1. Open the master page in the Document window.