ArcGIS Desktop

  • Documentation
  • Support

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

Help

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

Relating the attributes in one table to another

Relates defined in ArcMap are essentially the same as simple relationship classes defined in a geodatabase, except that they are saved with the map instead of in a geodatabase.

If a feature class in a geodatabase participates in a relationship class, that relationship class will be immediately available for use. You don't need to relate the tables in ArcMap.

Relates (or relationship classes) are the best way to associate data that has a 1:M relationship.

  1. Right-click the layer you want to relate, point to Joins & Relates, then click Relate.

    You can also click the Table Options button Table Options on an open Table window to access the Relate dialog box.

  2. Choose the field in the layer on which the relate will be based.
  3. Choose the table or layer to relate to, or load the table from disk.
  4. Choose the field in the related table on which to base the relate.
  5. Type a name for the relate.

    You'll use this name to access the related data.

  6. Click OK.

    The relate is now established between the two tables. Refer to the topic Accessing related records for information on how to work with relates.

Related topics

  • About joining and relating tables
  • Essentials of relating tables
  • Accessing related records
  • Managing related tables

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS Platform

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

About Esri

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