Operation Manual

578
USING DREAMWEAVER
Building applications visually
Last updated 3/28/2012
Recordset columns selected for a master 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.
The recordset can be defined by the user at run time. For more information, see “Building search and results pages”
on page 583.
3 Insert a dynamic table to display the records.
Place the insertion point where you want the dynamic table to appear on the page. Select Insert > Data Objects >
Dynamic Data
> Dynamic Table, set the options, and click OK.
If you don’t want to show record IDs to users, you can delete the column from the dynamic table. Click anywhere on
the page to move the focus to the page. Move the cursor near the top of the column in the dynamic table until the
column cells are outlined in red, and then click to select the column. Press Delete to delete the column from the table.
More Help topics
“Define a recordset without writing SQL” on page 536
“Define an advanced recordset by writing SQL” on page 538
“Create a dynamic table” on page 560
Create links to the detail page
After building the master page and adding the recordset, you create links that open the detail page. You then modify
the links to pass the IDs of the records the user selects. The detail page uses this ID to find the requested record in the
database and display it.
Note: You create links to update pages using the same process. The results page is similar to a master page, and the update
page is similar to a detail page.
More Help topics
“Building an update record page” on page 592