Creating a master page and defining a recordset for it (ASP and JSP)

The first step in building master/detail pages is to create a blank master page and add a recordset to it.

You can define a recordset at design time (see Defining a recordset) or the user can define one at runtime (see Building search/results pages (ASP and JSP)).

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.

The next step in creating master/detail pages is to display the records on the master page. See Displaying the records on the master page (ASP and JSP).