Support for multiple 1-M relationships in a single relationship class

03-02-2021 05:01 PM
Labels (2)
Occasional Contributor III


In AGOL, is there a way for a relationship class to have multiple 1-M relationships? Here is my use case...
I have a main table of CASES. Each case can have one-to-many CREWS assigned. Each crew can perform one-to-many TASKS. Each task could have various other attributes like time spent.

I am imagining a single relationship table that has (See image below)
-some other attributes

Is there a way to support a schema like that in AGOL? If that is not supported, any ideas how best to implement my scenario?

Simplified CaseCrewTasks ERDSimplified CaseCrewTasks ERD


Tags (3)
0 Replies