https://community.esri.com/t5/arcgis-online-questions/support-for-multiple-1-m-relationships-in-a-single/m-p/1032289#M38742 <P>Hello.</P><P>In AGOL, is there a way for a relationship class to have multiple 1-M relationships? Here is my use case...<BR />I have a main table of <STRONG>CASES</STRONG>. Each case can have one-to-many <STRONG>CREWS</STRONG> assigned. Each crew can perform one-to-many <STRONG>TASKS</STRONG>. Each task could have various other attributes like time spent.</P><P>I am imagining a single relationship table that has (See image below)<BR />-CaseId<BR />-CrewId<BR />-TaskId<BR />-some other attributes</P><P>Is there a way to support a schema like that in AGOL?&nbsp;If that is not supported, any ideas how best to implement my scenario?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Simplified CaseCrewTasks ERD" style="width: 665px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/7384i3040EA2DFDCC4A3E/image-size/large?v=v2&amp;px=999" role="button" title="CaseCrewTasks.PNG" alt="Simplified CaseCrewTasks ERD" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Simplified CaseCrewTasks ERD</span></span></P><P>&nbsp;</P> Wed, 03 Mar 2021 01:01:43 GMT Trippetoe 2021-03-03T01:01:43Z https://community.esri.com/t5/arcgis-online-questions/support-for-multiple-1-m-relationships-in-a-single/m-p/1032289#M38742 <P>Hello.</P><P>In AGOL, is there a way for a relationship class to have multiple 1-M relationships? Here is my use case...<BR />I have a main table of <STRONG>CASES</STRONG>. Each case can have one-to-many <STRONG>CREWS</STRONG> assigned. Each crew can perform one-to-many <STRONG>TASKS</STRONG>. Each task could have various other attributes like time spent.</P><P>I am imagining a single relationship table that has (See image below)<BR />-CaseId<BR />-CrewId<BR />-TaskId<BR />-some other attributes</P><P>Is there a way to support a schema like that in AGOL?&nbsp;If that is not supported, any ideas how best to implement my scenario?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Simplified CaseCrewTasks ERD" style="width: 665px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/7384i3040EA2DFDCC4A3E/image-size/large?v=v2&amp;px=999" role="button" title="CaseCrewTasks.PNG" alt="Simplified CaseCrewTasks ERD" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Simplified CaseCrewTasks ERD</span></span></P><P>&nbsp;</P> Wed, 03 Mar 2021 01:01:43 GMT https://community.esri.com/t5/arcgis-online-questions/support-for-multiple-1-m-relationships-in-a-single/m-p/1032289#M38742 Trippetoe 2021-03-03T01:01:43Z