Methods of association between tables

Hala_Ghareeb — Tue, 15 Nov 2022 10:01:43 GMT

Hi all,

I was doing an exercise in an instructor-led course "Managing Geospatial data in ArcGIS", in page 3-13, the exercise was about defining the type of association: The last scenario says, "you have more than one matching record in the related table", which means the cardinality is 1:M so the compatible associations are Relationship Class and Relate.

Why does the answer in page 3-25 include Join?

Re: Methods of association between tables

Suzanne-Boden — Fri, 18 Nov 2022 23:53:00 GMT

Hi, in the ArcGIS Pro Help, I found this explanation:

When using data where a one-to-many or many-to-many relationship exists, use a relate or relationship class to establish the relationship between the datasets. However, you can create a join under these circumstances. When you create a join in such a case, there are differences between how tools and other layer-specific settings work depending on the data source. If you are using data in the same geodatabase to create the join, all matching records are returned. If you are using nondatabase data, such as shapefiles or dBASE tables, to create the join, only the first matching record is returned.

topic Re: Methods of association between tables in Esri Training Questions

Methods of association between tables

Re: Methods of association between tables