Hi everyone, 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. Thibaud -

Solved

Trying to do a lookup from a lookup

+6

Hi everyone,

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.

Thibaud -

Best answer by Nathalie_Collin

Could this be what you’re looking for? I updated your cousin field with this.

+18

Could this be what you’re looking for? I updated your cousin field with this.

+6

Great, thanks a lot :slightly_smiling_face:
I wasn’t looking through the right place.