Creating and using a Relate

A Join is just one of the basic methods you can use in ArcGIS Pro to link data together. Another method is a Relate. A Relate links two tables together, but unlike a Join, which adds information to the primary table, the two tables remain separate when related. This allows you to see all the related records in the linked table.

A Relate works best when you have one record in your primary table which matches to multiple records in the linked table, or when you have multiple records in the primary that match multiple records in the linked table. In these situations, a Join would not work as well because it would have multiple records which match.   

In this recipe, you will create a Relate between the Parcels and a land sales table. The land sales table contains all parcels sales which have occurred over the last several years. This table also comes from the County’s CAMA system, like the Owners table did. Once you relate the two tables, you will see how you can view all the sales for a selected parcel.