I am trying to do a lookup from another lookup.
To illustrate my request, I have created this base
The first field is the close family relationship to Mister A.
- Mister A has parents and children > Linked record fields
- Mister A has Grand parents, Brothers and sisters, Uncles and aunts > Look-up fields
But I can’t create a lookup from another lookup to have a field with Mister A’s Cousins.
Can someone can help me to create a look-up or a formula to display Mr. A’s cousins in a new field.
Thanks in advance.