Creating an attributed relationship class

Available with Standard or Advanced license.

Note:

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

Any relationship class—whether simple or composite, of any particular cardinality—can have attributes. Relationship classes with attributes are stored in a table in the database. This table contains at least the foreign key to the origin feature class or table and the foreign key to the destination feature class or table.

An attributed relationship can also contain any other attribute. The example in this subtask shows how to create a simple relationship between a feature class that stores water laterals and a feature class that stores hydrants.

Water lateral objects have their own attributes, and hydrant objects have their own attributes. The relationship class in this example describes which water laterals feed which hydrants. Because you want to store some kind of information about that relationship—such as the type of riser connecting the two—you can store this information as attributes in the relationship class.

Learn more about creating a simple relationship class

Learn more about creating a composite relationship class

1. In the Catalog tree, right-click the geodatabase or feature dataset in which you want to create the new relationship class and point to New > Relationship Class.
2. Type the name for the new relationship class.
3. Click the Origin table or feature class.
4. Click the Destination table or feature class.
5. Click Next.
6. Click Simple (peer-to-peer) relationship.
7. Click Next.
8. Type the forward and backward path labels.
9. Click the message notification direction.
10. Click Next.
11. Click the first cardinality option. In this example, an owner can own a single parcel, and a parcel can be owned by a single owner, so this is a one-to-one (1:1) relationship.
12. Click Next.
13. Click the first option to add attributes to the relationship class.
14. Click Next.
15. To add a field, click the next row in the Field Name column, then type a name.
16. Click in the Data Type field next to the new field's name, then click its data type.
17. Set the new field's properties in the dialog box below.
18. Repeat steps 15 through 17 until all the relationship class's fields have been defined.
19. Click Next.
20. Click the drop-down arrow to see a list of fields from the Origin table or feature class. Click the primary key for this feature class or table.
21. Type the name of the foreign key field for the Origin table or feature class.
22. Click the drop-down arrow to see a list of fields from the Destination table or feature class. Click the primary key for this feature class or table.
23. Type the name of the foreign key field for the Destination table or feature class.
24. Click Next.
25. Review the options you specified for your new relationship class. If you want to change something, you can go back through the wizard by clicking Back.
26. Click Finish to create the new relationship class when satisfied with your options.

Tip:

In an attributed relationship, the Relationship table must have fields that act as foreign keys to the Origin and Destination feature classes or tables. These foreign keys relate to the primary keys on the Origin and Destination feature class or table primary keys.