By using a filter, you can find records based on whether they contain a specific value in a particular field. For example, you can find all records that have "Germany" in the Country field. When you apply the filter, only the records that contain the value you selected will appear in the data access page. Once you remove the filter, all the records will be displayed again. For grouped data access pages, you can filter the list of groups (the group headings) or the records within groups.
Do one of the following:
In an ungrouped page
In a grouped page
Expand the group that you want to filter.
Move focus to the field that has the value that you want to use to filter records.
Click Filter By Selection on the record navigation toolbar for that group.
The filter applies only to the current group. In other words, if a page groups customer orders by country, and you filter the records for Brazil that have a required date of 6/2/98, that filter applies only to the records for Brazil, not to the records for the other countries.
To further narrow the subset of records, continue selecting fields and clicking Filter By Selection until you have just the records you want.
For example, if you want to see records only for customers in Germany with a required date of 5/12/98, select "Germany" in the Country field, click Filter By Selection, select "5/12/98" in the Required Date field, and then click Filter By Selection again.
Notes