How to: Filter Records in Tables
You can specify that only certain records display in browse windows by setting a data filter.
Warning
If you restrict access to all the fields in a table, you might not be able to open the table in a browse window.
To filter records in a browse window
Open the table in a browse window.
On the Table menu, click Properties to open the Work Area Properties dialog box.
In the Data filter box, type the filter expression you want. To build an expression, click the ellipsis (...) button.
Click OK.
The browse window displays only those records that meet the filter expression.
For example, the following filter expression displays on those records in a Customer table where the Country field is set to "USA":
Customer.Country = "USA"
See Also
Tasks
How to: Navigate Records in Tables
How to: View Records in Tables
How to: Configure Browse Windows or Grids