topic How to Create Many-to-Many Relate in ArcMap? in Mapping Questions https://community.esri.com/t5/mapping-questions/how-to-create-many-to-many-relate-in-arcmap/m-p/330930#M3526 <HTML><HEAD></HEAD><BODY><P>Has anyone had any success specifying many-to-many cardinality when creating an ArcMap Relate?&nbsp; </P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>What I've tried:&nbsp; The Relate dialog lets me pick the primary key field, the target table, the foreign key field, and then it lets me name the relate.&nbsp; I don't get to specify cardinality as I do when creating a geodatabase relationship class.&nbsp; The end result appears to support a 1:1 or 1:M relate, but befuddles me regarding the advertised and desired M:N relate.&nbsp; The <A class="jive-link-external-small" href="http://resources.arcgis.com/en/help/main/10.2/004t/004t00000002000000.htm" rel="nofollow" target="_blank">instructions suggest</A> that an ArcMap M:N relate is supported, but the "how to" information is elusive. </P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>Hopefully, I'm just slipping up somewhere... surely there's a button to press to specify cardinality and make it work.</P></BODY></HTML> Fri, 15 Aug 2014 23:23:32 GMT TimMinter 2014-08-15T23:23:32Z How to Create Many-to-Many Relate in ArcMap? https://community.esri.com/t5/mapping-questions/how-to-create-many-to-many-relate-in-arcmap/m-p/330930#M3526 <HTML><HEAD></HEAD><BODY><P>Has anyone had any success specifying many-to-many cardinality when creating an ArcMap Relate?&nbsp; </P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>What I've tried:&nbsp; The Relate dialog lets me pick the primary key field, the target table, the foreign key field, and then it lets me name the relate.&nbsp; I don't get to specify cardinality as I do when creating a geodatabase relationship class.&nbsp; The end result appears to support a 1:1 or 1:M relate, but befuddles me regarding the advertised and desired M:N relate.&nbsp; The <A class="jive-link-external-small" href="http://resources.arcgis.com/en/help/main/10.2/004t/004t00000002000000.htm" rel="nofollow" target="_blank">instructions suggest</A> that an ArcMap M:N relate is supported, but the "how to" information is elusive. </P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>Hopefully, I'm just slipping up somewhere... surely there's a button to press to specify cardinality and make it work.</P></BODY></HTML> Fri, 15 Aug 2014 23:23:32 GMT https://community.esri.com/t5/mapping-questions/how-to-create-many-to-many-relate-in-arcmap/m-p/330930#M3526 TimMinter 2014-08-15T23:23:32Z Re: How to Create Many-to-Many Relate in ArcMap? https://community.esri.com/t5/mapping-questions/how-to-create-many-to-many-relate-in-arcmap/m-p/330931#M3527 <HTML><HEAD></HEAD><BODY><P>Hi Tim,</P><P></P><P>On the fly M:N relate works just fine. The steps you followed will establish M:N relate if there is an M:N cardinality between your table attributes. You don't have to specify the cardinality explicitly as you would when you create a relationship class. Refer screenshot of M:N relate i created on the fly.</P><P></P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.esri.com/legacyfs/online/3550_Untitled.png" style="width: 620px; height: 481px;" /></P></BODY></HTML> Sat, 16 Aug 2014 11:16:53 GMT https://community.esri.com/t5/mapping-questions/how-to-create-many-to-many-relate-in-arcmap/m-p/330931#M3527 RiyasDeen 2014-08-16T11:16:53Z