To create a join
- Prepare to create a join by doing the
- 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.
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
- In Display Manager,
right-click a feature layer Create A Join.
you create a join, this command changes to Joins Manage Joins
displays the Manage Layer Data dialog box
In that dialog box, you can add, edit, or delete joins.
The layer you right-click is the primary source.
- In the Table (Or Feature Class)
To Join To list in the Create A Join dialog box,
select the table or feature class whose data you will to join to
Your selection is the
secondary source. If this source contains multiple tables, choose
the one to use for the join.
- In the This Column From The
Left Table list, select the join key (the common field
or property) for the primary source, for example, Parcel_ID or County_Name.
- In the Matches This Column
From The Right Table list, select the matching field
or property in the secondary source.
Only fields with matching
data types are displayed in the right-hand list. The fields need
not have the same name in both data sources, but they must have
the same data type (numeric, string, Boolean, and so on). For example,
you can match the Parcel_ID field in one table to the Lot_Number
field in the second table, so long as Parcel_ID and Lot_Number use
the same data type.
- Under Type Of Joins,
select the type of join to create:
- Keep All Records On
The Left (a left outer join)
- Keep Only Left-Side
Records With A Match (an inner join)
- Under Relationship With Secondary
Records (Cardinality), choose one of the following:
- One-To-One matches
one secondary source record to each primary source item. Any extra
secondary source records are ignored.
- One-To-Many creates
a new feature for each extra record in the secondary source.
- Click OK.
In the Data
Table for the primary source (the feature
layer to which you joined the data), the newly joined properties
are appended to the right of the native feature data. The joined
properties are gray, to indicate that they are read-only. In the
column title, the name of the table you joined precedes the property
edit joined data, you must edit the secondary source itself, and
not the layer to which it is joined. See Editing Joined Data