I have a table of people, and want to represent a family tree, so I’d like to have two fields, mother and father, that link to people in the same table. Obviously a parent could have more than one child.
How should I set this up? I’d like to be able to select the parent from the table instead of typing in the name. Pick lists don’t maintain relationships so are not and option.
This is on iOS.
Hi Simon,
You’ll need to add a Link to Form field to your form that links to itself. Choose the Many to Many option because a child can have more than one parent. Don’t turn on the Show Inverse Relationship option. It will automatically show the parents in the same field on the child records. So you’ll want to give the field a more generic name than Parents or Children. Maybe something like Relations.
Thanks,
Brendan
Perhaps an improvement could be a graph link type that supported this sort of self-linking use case, perhaps with labels for directionality of relationship. This might also work for the tagging use as well to model that relationship.
.
