Master Detail Page Set

1
Master Detail Page Set

• Enabling Users to See More Detailed Data

2
Master Detail Page Set

• When a data table contains too many fields to
  display all at once, you can display a master
  page that lists a record summary with links the
  user clicks to see more detail.
• To help you do this, Dreamweaver has an
  Application object called the Master Detail Page
  Set server behavior.
• The following tutorial steps you through the
  process of creating a Master Detail Page Set.

3
Create an ASP Page

• Pull down the File menu and choose New to bring
  up the New Document dialog.
• Select the Dynamic Page category to make the
  Dynamic Page options appear.
• Select ASP JavaScript and click the Create
  button the new page appears.
• Pull down the File menu, choose Save, and save
  the file in your sites local root folder in
  this example, make the name of the page be
  MasterDetail.asp.

4
Defining the Data Source

• If you have not already defined the data source
  containing your table, follow these steps
• Click to position your cursor in the Databases
  window. If the Databases window is not visible,
  pull down the Window menu and choose Databases.
• Click the plus-sign button and choose Custom
  Connection String.
• When the Custom Connection String dialog appears,
  enter the name of the connection and your
  connection string.

5
Entering the Connection String

• In this course, the connection string
  is"DBQC\webs.oet.udel.edu\fthstudents\databa
  ses\lastname\TopSecret.mdbDRIVERMicrosoft
  Access Driver (.mdb)
• -or-
• "ProviderMicrosoft.Jet.OLEDB.4.0Data
  SourceC\webs.oet.udel.edu\fthstudents\databases
  \lastname\TopSecret.mdb
• If you are running your own Web server, you can
  use the my.udl wizard to create the connection
  string.

6
Create a Recordset Data Binding

• Click the Bindings tab of the Application window,
  or pull down the Window menu and choose Bindings.
• Click the plus sign button and choose recordset
  to make the recordset dialog appear.
• Customize the Name field to suit your
  application. If this is a list of users, for
  example, make the Name field say UsersRecordset.
• Choose the connection that contains the table.
• Select the data table containing all of the data.
• Select the data fields you want displayed on the
  master page as well as the detail page in this
  example, choose all the data fields.
• Click OK.

7
Select the Application Toolbar

• If the Insert toolbar is not already set to
  Application, pull down the toolbar menu by
  clicking the arrow near the left of the toolbar
  bar and choose Application to make the
  Application toolbar appear

8
Insert the Master Detail Page Set

• Click to position the cursor at the spot on the
  page where you want the master part of the page
  set to appear.
• On the Application toolbar, click the Master
  Detail Page Set Tool

9
Set the Master Detail Page Set Options
In the Detail page name field, enter the name you
want the page to have, or use the Browse button
to select the name of an existing active server
page. Click OK when you are done setting these
options.
10
Test the Master Detail Page Set

• Save the newly created master and detail pages
  and publish them to your Web site.
• Browse to the master page and see how it appears
  onscreen.
• Click ID numbers on the master page to see the
  corresponding detail on the detail page.

11
Adjust the Page Layout

• Stylize the page elements as you wish.
• Use a surrounding table, for example, to make the
  master table, the navigation bar, and the status
  report align with each other as follows