Hello,
Is there a way to select multiple columns to act as reference pointing to another same table.
Currently, I am trying to do it manually one-by-one…
My data structure is like so:
List Table → List Funds Table → Funds Attributes Table
I got the first reference done. As in when entering into a List, there is a view/list of the Funds within that List. Perfect!
The idea now that user can also click on further to bring them to another view/list where the attributes of that particular Funds will show.
If i were to do it manually, it will work. But I am having over 99 columns to do references to a single/same another table.
Wondering if there is sort of formula or can select multiple columns at the same time or make the columns into an array. Screenshot below as example what I meant:
