Operation Manual

582
USING DREAMWEAVER
Building applications visually
Last updated 3/28/2012
Build master and detail pages in one operation
When developing web applications, you can quickly build master and detail pages using the Master Detail Page Set
data object.
1 To create a blank dynamic page, select File > New > Blank Page, select a dynamic page from the Page Type list, and
click Create.
This page becomes the master page.
2 Define a recordset for the page.
Make sure the recordset contains not only all the columns you’ll need for the master page, but also all the columns
you’ll need for the detail page. Typically, the recordset on the master page extracts a few columns from a database table
while the recordset on the detail page extracts more columns from the same table to provide the extra detail.
3 Open the master page in Design view, and select Insert > Data Objects > Master Detail Page Set.
4 In the Recordset pop-up menu, make sure the recordset containing the records you want to display on the master
page is chosen.
5 In the Master Page Fields area, select the recordset columns to display on the master page.
By default, all the columns in the recordset are selected. If your recordset contains a unique key column such as
recordID, select it and click the Minus (-) button so that it is not displayed on your page.
6 To change the order in which the columns appear on the master page, select a column in the list and click the up
or down arrow.
On the master page, the recordset columns will be arranged horizontally in a table. Clicking the up arrow moves the
column to the left; clicking the down arrow moves the column to the right.
7 In the Link To Detail From pop-up menu, select the column in the recordset that will display a value that also serves
as a link to the detail page.
For example, if you want each product name on your master page to have a link to the detail page, select the recordset
column containing product names.
8 In the Pass Unique Key pop-up menu, select the column in the recordset containing values identifying the records.
Usually, the column chosen is the record ID number. This value is passed to the detail page so that it can identify the
record chosen by the user.
9 Deselect the Numeric option if the unique key column is not numeric.
Note: This option is selected by default; it does not appear for all server models.
10 Specify the number of records to display on the master page.
11 In the Detail Page Name box, click Browse and locate the detail page file you created, or enter a name and let the
data object create one for you.
12 In the Detail Page Fields area, select the columns to be displayed on the detail page.
By default, all the columns in the master page’s recordset are selected. If the recordset contains a unique key column
such as
recordID, select it and click the Minus (-) button so that it is not displayed on the detail page.
13 To change the order in which the columns appear on the detail page, select a column in the list and click the up or
down arrow.
On the detail page, the recordset columns are arranged vertically in a table. Clicking the up arrow moves the column
up; clicking the down arrow moves the column down.
14 Click OK.