Exercise 3: Join the data from the ODBC source to the layer containing the parcels

After you connect to an external data source, you can join it to a layer in your map using the Data Table. This method works as long as the two data sources share a common property. You can see the results of the join immediately.

NoteThis exercise uses the AnalyzeMap1.dwg map you created and modified in the previous exercises.

To join the ODBC parcel data to the geospatial parcel layer

  1. In Display Manager, select the Parcels layer and click Table.
  2. At the bottom of the Data Table, click Options Create A Join.

    In the Create A Join dialog box, the Primary Table Initiating The Join entry is automatically displayed.

  3. For Table (Or Feature Class) To Join To, select the ODBC_1:Fdo:Assessor layer.
  4. For This Column From The Left Table, select APN.

    The entry for the corresponding Matches This Column From The Right Table is automatically displayed.

  5. Click OK to display all the data in the Data Table.
  6. Scroll to the right to see the owner information.

To continue this tutorial, go to Exercise 4: Use the joined data for calculated fields and styles.