Hello, Im trying to link a table back to itself; My situation is as follows:
A User has 2 or 0 Parents;
Each Parent is also a User;
I tried using the relation tool to set ElementID and Child ID as a 1-N relationship but it throws an error each time
how should I go about this
Put the relation in a second table. You have to decide, if you put parent-of or child-of in that table.
.
Then you use two columns
User, ChildOf and put the Ids of the original table here. Now try to set your 1-N-relation to this table.
.
If you really want to enforce 0 or 2 parents, you have to do this by another way, but I would not recommend it anyway.