I’m trying to create a report containing data from 3 tables which are linked.
For the report I need to setup a nested repeat loop to traverse Table1 and use one of its column data (C1) as the key to the Table2 and use one of its column data (C2) as the key to another Table3.
Based on one of the templates I think I need to use FormulaMap and _DEREF functions.
I can’t find any documentation on how to use the _DEREF function.
Would appreciate any help in alternate ways to setup nested repeat loops or documentation on _DEREF function.