Datasheet

Developing Master and Detail Pages Block by Block
698
4. Select a database connection for obtaining the data that you want to
display.
5. Select a table name for obtaining the data that you want to display.
After you select a table name, the database columns appear in the
Columns list.
6. Select which columns should provide the record data to display.
Typically, your detail page uses more columns than your master page.
You want the recordset for your detail page to contain at least one
column (generally the id field) that matches the column that you use for
the master page.
7. Complete the Filter sections as follows:
The first Filter field: Select the database column name that contains
values to match against the URL parameter (specified in the “Setting
up links to open a detail page” section earlier in this chapter). You
use the filter to find and display the record specified by the URL
parameter passed from the master page.
The second Filter field: Select the equals (=) symbol, if it’s not
already selected. This requires the fields to be equal, which they
must be to display only the record that is detailed.
The third Filter field: Select the URL parameter.
The fourth Filter field: Enter the name of the URL parameter that
you want the master page to pass to the detail page.
The recordset (see Figure 1-8) now returns only the data for the
employee who’s been selected on the master page.
Figure 1-8:
Defining
a detail
recordset.