Support for multiple 1-M relationships in a single relationship class
589
0
03-02-2021 05:01 PM
by
Hello.
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)
-CaseId
-CrewId
-TaskId
-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?
