Hi, I am struggling with a combo of split, multiple relation and lookup…
As illustrated in the picture below, the objective is to
- table [company]: assign some “advisor(s)” to a company, knowing that 1 advisor can be in several companies
- table [user]: find the company(ies) assigned to each advisor.
I don’t get why the Lookup function does not work, while the Relation works…?
Many thanks for your insights