I’m experiencing something unusual, I’m pretty sure my formula used to work, but…maybe not.
I have various tables:
- Detail_File (children of File)
Each Detail_File has 1 “related business” column.
Each business owns properties, and among these: business managers1 and business manager2 in particular (let’s call them BM1 and BM2)
My need is to have a list of ref at the File level, referencing all business managers from the whole related detail_file items.
My formula is:
[Related key_Managers]= [Related key_Business][key_BM1]+[Related key_Business][key_BM2]
[Related key_Managers] is of type List of Ref, referring to employees table.
[Related key_Business] is of type List of Ref, referring to businesses table.
…No manager comes back to the File level, although [Related key_Business] displays a list of businesses as expected.
In addition, when I look to the table of businesses, the BM1 and BM2 are well reported (as well as all the other businesses properties).
Any clue on what may have gone wrong ?
Many thanks in advance