js editor
Web development
You can specify that only certain records display in browse windows by setting a data filter.
 Caution: |
|---|
| 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":
| В |  Copy Code |
|---|---|
Customer.Country = "USA" | |