Datasheet

740
3. In the Name text box, enter a name for your recordset.
You can use only letters, numbers, and underscores in the name.
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 filter requires the fields to be equal, which
they must be to display only the detailed record.
The third Filter field: Select 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.
Developing Master and Detail Pages Block by Block
53_610770-bk09ch01.indd 74053_610770-bk09ch01.indd 740 5/6/10 1:20 PM5/6/10 1:20 PM