ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

ArcMap

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • Extensions

Appending related fields with a join

Available with Standard or Advanced license.

Note:

Although relationship classes can be both created and edited in ArcGIS Desktop Advancedand ArcGIS Desktop Standard, they are read-only in ArcGIS Desktop Basic. The feature classes participating in a relationship class will also be read-only in ArcGIS Desktop Basic.

The fields of a related class are not automatically joined to a class's attribute table. This is because one-to-many and many-to-many cardinalities do not support this type of visualization. Also, a given table or feature class may participate in multiple relationship classes that access a large number of related fields, most of which you might not need for a given task.

For one-to-one and many-to-one (really the same as a one-to-one) relationship classes, use an ArcMap join to append the related fields from a specific related class to a table. This helps avoid cluttering it with fields you do not need. You can create a join based on an existing relationship class, which is quicker than specifying all the properties normally needed to define a join. Once you have created the join, the fields from the related feature class or table are added to your feature layer. You can use these fields for labeling, symbolizing, and querying your features.

The Attribute dialog box always provides access to all of a class's related fields, whether or not a join has been created.

  1. Right-click the feature layer in the ArcMap table of contents.
  2. Point to Joins and Relates and click Join.
  3. Click the Join Options drop-down arrow and click Join data based on a predefined relationship class.
  4. Click the drop-down arrow to get a list of relationship classes, then click the relationship class.
  5. Click OK.
  6. You can now use the related fields for labeling, symbolizing, and querying your features.

Tip:
If the relationship class is one-to-many, each feature can have multiple related objects. In this case, the attributes of the first related object are joined to the feature.
Tip:
ArcMap has tools for editing relationships. Learn more about editing relationships.

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS
  • ArcGIS Developer
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2021 Esri. | Privacy | Legal