ArcGIS for Desktop

  • Documentation
  • Pricing
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS for Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS for Desktop

A complete professional GIS

ArcGIS for Server

GIS in your enterprise

ArcGIS for 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
  • Pricing
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

Appending related fields with a join

Available with Standard or Advanced license.

Note:

Although relationship classes can be both created and edited in ArcGIS for Desktop Advancedand ArcGIS for Desktop Standard, they are read-only in ArcGIS for Desktop Basic. The feature classes participating in a relationship class will also be read-only in ArcGIS for 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.
Feedback on this topic?

ArcGIS for Desktop

  • Home
  • Documentation
  • Pricing
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS for Desktop
  • ArcGIS for Server
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Insiders Blog
  • User Conference
  • Developer Summit
Esri
© Copyright 2016 Environmental Systems Research Institute, Inc. | Privacy | Legal