<% @language=VBScript %> Database Elements, Filters
Corporate View


Table, Records, and Fields

Database Elements
Page 4 of 6


A filter displays records in a database according to criteria you select. Although the database used as an example in this seminar is small, a database can contain a large amount of data. You might want to filter the data, hiding some records and displaying others. For example, you might want to display records for Operator CS1 only. A filter allows you to do so easily.

Figure 7 shows the Complaints table. CS1 is selected in the Operator field and the arrow is pointing to the Filter By Selection button. Clicking the Filter By Selection button will display only records with CS1 in the Operator field, as shown in Figure 8.

Figure 7 Complaints Table

Figure 8 Complaints Table With Filter Applied

The other records are still in the table even though they are not displayed. The filter can be removed to display all the records in the table.

Page 4 of 6