This dialog box defines a recordset as a source of dynamic content without you having to hand code SQL statements.
-
In the Name text box, enter a name for the recordset.
A common practice is to add the prefix rs to recordset names to distinguish them from other object names in the code. For example: rsPressReleases
Note that recordset names can only contain letters, numbers, and the underscore character (_). You cannot use special characters or spaces.
-
Select a connection from the Connection pop-up menu.
If no connection appears in the list, click Define to create one.
-
In the Table pop-up menu, select the database table that will provide data to the recordset.
The pop-up menu displays all tables in the specified database.
-
To include only some of the table's columns in the recordset, click Selected and choose the desired columns by Control-clicking (Windows) or Command-clicking (Macintosh) them in the list.
-
To include only some of the table's records, complete the Filter section as follows:
- From the first pop-up menu, select a column in the database table to compare against a test value you define.
- From the second pop-up menu, select a conditional expression to compare the selected value in each record against the test value.
- From the third pop-up menu, select Entered Value.
- In the text box, enter the test value.
If the specified value in a record meets your filtering condition, the record is included
the recordset.
-
If you want the records to be sorted, select a column to sort by, and then specify whether the records should be sorted in ascending order (1, 2, 3... or A, B, C...) or descending order.
-
Click Test to connect to the database and create an instance of the data source.
A table appears displaying the returned data. Each row contains a record and each column represents a field in that record. Click OK to close the data source.
-
Click OK.
The newly defined recordset appears in the Bindings panel.