2011

■ Using Joins with Calculated Properties
(page 518)
■
Accessing Data from ODBC (page 342)
■ Overview of the Data Table (page 1125)
NOTE Joins are available for geospatial data only, and not for drawing objects.
To join attribute data to drawing objects, see
Overview of Linking Database Records
to Objects
(page 522).
To create a join
1 Prepare to create a join by doing the following:
■ Ensure the primary and secondary sources share one or more common
fields, for example Parcel_ID or County_Name. These fields do not
have to have the same name in both sources, but they must use the
same data type.
■ Simplify your secondary table data as much as possible. For example,
remove unnecessary records or tables.
■ Connect to both the primary and secondary sources using one of the
FDO Providers in Data Connect. When you connect to a secondary
source that has no geometry data, you need not add anything to the
map—you can just establish the connection and close the Data
Connect window.
NOTE If your secondary source is a Microsoft Access or Microsoft Excel
table, connect to it using an ODBC connection. For information about
setting up ODBC sources, see Accessing Data from ODBC (page 342).
2 In Display Manager, right-click a feature layer ➤ Create A Join.
NOTE Once you create a join, this command changes to Joins ➤ Manage
Joins and displays the
Manage Layer Data dialog box (page 1607). In that dialog
box, you can add, edit, or delete joins.
The layer you right-click is the primary source.
3 In the Table (Or Feature Class) To Join To list in the
Create a Join / Edit
a Join dialog box
(page 1603), select the table or feature class whose data
you will to join to the layer.
512 | Chapter 3 Bringing In Data