How To: Create a relate and query a related item in Edit Tools
Instructions provide the steps necessary to create a relate and perform an attribute query on a related item using Edit Tools.
The following example documents the creation of a relate between an arc coverage called ROADS and a stand alone INFO table called ROADS.LUT. The relate is based on the numeric item ROADS-ID that exists in both tables. The attribute query is performed on an item called VALUE that exists in the related table ROADS.LUT.
Click File > Open and choose to display the ARC feature class from the ROADS coverage.
Choose ArcTools > Manage > Relates.
Click the 'Add INFO' button.
Enter the following parameters:
Code: Relate Name: ROADREL From Item: ROADS-ID To Table: ROADS.LUT To Item: ROADS-ID Relate Type: LINEAR Access: READ-ONLY
Note: Some options require right-clicking the available text box and browsing for the proper selection.
Click OK in the Add INFO Relate and Relate Environment dialog boxes
Click Table Manager on the Edit Arcs & Nodes menu.
Highlight the VALUE item and click Apply. This will add the ROADREL//VALUE item to the list of available items to the query.
Click Dismiss on the Relate Browser dialog box. Click OK on the dialog box listing the available items.
Click Edit > Attribute Selection.
In the Logical Selection menu, build a selection expression using the related item, such as 'ROADREL//VALUE = 3', and click Apply Expression to execute the query. The features with related values matching this query are selected.