The Tables pane lists all tables that contain data stored by location. If the table also stores data by year, the Has Year? check box will be selected. This allows you to use the drop-down list in the Year column to select a specific year for the data in the table.
| Note: You cannot select the check box in the Select column directly. The system automatically selects this check box when you select a column from the table in the Columns pane. |
When you right-click a record in this pane, a drop-down menu opens containing the common commands along with the following special command:
- Apply Filter for This Table: This command opens the Filter pop-up, which allows you to set the filter criteria for a non-location-specifying column of the selected table. Once set, the system places a check mark in the Filtered? check box to denote that the table is filtered. It will also show a description of the filter in the Filter Description column of the Columns pane for the filtered column. If you want to set a filter for a column specifying a location, which would apply to all tables, use the Apply Location Filter for All Tables command that is found in the right-click shortcut menu launched from the Location Filter Pane.