You can specify that only certain records display in browse windows by setting a data filter.
|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.
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"