topic how to set many-to-many relation? in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/how-to-set-many-to-many-relation/m-p/569450#M25058 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I'm using ArcGIS Pro&nbsp;&nbsp;&nbsp;</P><P>I have connected between 'LandParcel' and 'TenantID' table by 'many-to-many' relationship</P><P><IMG alt="" class="jive-emoji image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/485214_Picture1.jpg" /></P><P>I created relation class between them. However, it didn't work well.</P><P>I tried to put primary and foreign key differently, but it failed.</P><P>When I add to new relationship in 'edit' window, new window indicated that 'there was invalid foreign key value'</P><P>How can I put correct set-up and build rule between them?</P></BODY></HTML> Sun, 15 Mar 2020 22:34:31 GMT DoyoonKim 2020-03-15T22:34:31Z how to set many-to-many relation? https://community.esri.com/t5/arcgis-pro-questions/how-to-set-many-to-many-relation/m-p/569450#M25058 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I'm using ArcGIS Pro&nbsp;&nbsp;&nbsp;</P><P>I have connected between 'LandParcel' and 'TenantID' table by 'many-to-many' relationship</P><P><IMG alt="" class="jive-emoji image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/485214_Picture1.jpg" /></P><P>I created relation class between them. However, it didn't work well.</P><P>I tried to put primary and foreign key differently, but it failed.</P><P>When I add to new relationship in 'edit' window, new window indicated that 'there was invalid foreign key value'</P><P>How can I put correct set-up and build rule between them?</P></BODY></HTML> Sun, 15 Mar 2020 22:34:31 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-set-many-to-many-relation/m-p/569450#M25058 DoyoonKim 2020-03-15T22:34:31Z Re: how to set many-to-many relation? https://community.esri.com/t5/arcgis-pro-questions/how-to-set-many-to-many-relation/m-p/569451#M25059 <HTML><HEAD></HEAD><BODY><P>One thing to check in a M:M relationship class with a Primary Key is it is set to "Allow Null Values."?&nbsp; If so, uncheck this.&nbsp; Does the error persist?</P></BODY></HTML> Mon, 16 Mar 2020 16:24:23 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-set-many-to-many-relation/m-p/569451#M25059 Robert_LeClair 2020-03-16T16:24:23Z Re: how to set many-to-many relation? https://community.esri.com/t5/arcgis-pro-questions/how-to-set-many-to-many-relation/m-p/569452#M25060 <HTML><HEAD></HEAD><BODY><P>Thanks for reply</P><P>I found how to cope with that by creating new tables, then connecting two tables.</P></BODY></HTML> Mon, 16 Mar 2020 18:16:38 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-set-many-to-many-relation/m-p/569452#M25060 DoyoonKim 2020-03-16T18:16:38Z