It is useful for analytical purposes to filter the data in a Browser window and then see the results display on a map. You can do this after creating a filter/sort by selecting the Add to Map option from the Sort and Filter group on the TABLE tab. This option lets you create a new named query and then add it to an existing or to a new Map window.
The Add to Map option is active after having applied a filter and/or sort and when the table in the Browser window contains mappable objects.
To add a new named query to an existing or new Map window:
-
Click the TABLE tab and then select Add to Map from the Sort and Filter group.. The Create Query dialog box displays.
-
In the New query name text box, enter a name to apply to the query result, or use the default name.
Query names can be up to 31 characters and cannot have special characters, such as spaces, in them. If you use spaces in the query name, they are converted to underscores, so that "Accounts 2000" becomes "Accounts_2000" for example.
-
Select the Open a new Browser for this query check box if you want the results of this query to open in a new Browser window.
-
Select the Add this query as a layer to check box to add the results of this query as a layer to:
- An existing map - Select this option and a Map window from the drop-down list, which contains the names of the existing Map windows.
- A new map named - Select this option and then type a name for the new Map window in the textbox. If a table is not mappable, then the Add This Query As A Layer check box is grayed out and unavailable.
-
Click OK to apply your selections.
The resulting query reflects the current state of the Browser window. After creating the query, you can perform other operations in the Browser window without affecting the query, such as modifying your sort and/or filter conditions, or closing the Browser window. However, if you close the original table, the query automatically closes too.