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...

Creating relationship rules

Available with Standard or Advanced license.

Note:

Although relationship classes can be both created and edited in ArcGIS for Desktop Advanced and 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.

When you create a relationship class, you create it with an initial cardinality, such as one-to-many or many-to-many. In a real system, however, relationship cardinalities are more specific. Once you've created the relationship class, you can refine the cardinality by creating rules. Relationship rules allow you to restrict the type of objects in the origin feature class or table that can be related to a certain kind of object in the destination feature class or table.

For an illustration of this task, review Creating relationship rules.

  1. Right-click the relationship class in the Catalog tree.
  2. Click Properties.
  3. Click the Rules tab.
  4. If your origin class has subtypes, click the subtype to which you want to associate a relationship rule. If the origin class has no subtypes, the relationship rule applies to all features.
  5. If the destination class has subtypes, check the subtype that you want to relate to the selected subtype in the origin class. If the destination class has no subtypes, the relationship rule applies to all features.

    If one or both sides of the relationship class is many, you can limit the specific range of cardinality. In this example, the origin side of the relationship is one, so you can't modify its range. However, the destination side is many, so you can modify its range.

  6. Check the check box to specify the range of destination objects per related origin objects.
  7. Click the Up and Down arrows to increase or decrease the minimum and maximum number of related destination objects.
  8. Repeat steps 4 through 7 until you have specified all the relationship rules for this relationship class.
  9. Click OK or Apply to create the rules in the database.
Tip:
Once a relationship rule is added to a relationship class, that rule becomes the only valid relationship that can exist. To make other relationship combinations and cardinalities valid, you must create additional rules.

Related Topics

  • Creating a simple relationship class
  • Creating a composite relationship class
  • Creating an attributed relationship class
  • Relationship class properties
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