I have 3 bases (let’s call them small, joker, and big)
The entire relationship is built on ParentID and ChildID
Small is connected to a joker (small is the child of the joker)
Big is connected to joker (big is the parent of the joker)
Joker can be connected both to Big and Small, but the tricky part is that it can also be connected to itself (A Joker can have a child that is a Joker and a Parent that is a Joker)
I want to create a lookup in the Small base that shows me the name of the Big, which means that I need a script that looks at the parentID of the Joker and keeps going up the child-parent chain until it gets to the Big_ID.
Can someone help me with this?
Thank you in advance!