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?