When using the @ reference to populate a table values, is it possible to access other values in the object?
For example I have a table of [Fruit] and [Color] and I have a table of [President] and [Order].
Then I have a composite table:
Row 1 - @Apple
Row 2 - @GeorgeWashington
Is it possible to get any values from these references? For example is it possible to have a third column that is
Red for row 1 and
1 for row 2? It is not intuitive since they don’t share the same column values, but I think it could probably be done. Perhaps by manually creating an
Switch() condition where we hardcode the condition - checking
IsFromTable() and then constructing the logic based on which table they reference?