I was wondering if there is a way to use REF_ROW to retrieve rows from another table when the “ref-column” is a list?
REF_ROWS( " from-dataset " , " ref-column " )
I have two tables: Equipment, and maintenance.
Using EnumList Ref column types, I can assign equipments to each maintenance task I create, and viceversa, assign tasks to each new equipment I create.
This creates a List of Referred Equipments and Maintenance Tasks that is read like text separated with commas.
Im trying here to use REF_ROWS expression to get references to all equipments assigned to each Maintenance Task in the Maintenance Table, and vice versa: Get references to all Maintenance tasks assigned to each equipment in the Equipment Table.
Is this possible?