How to Fill a Virtual Column with Data from Another Table Easiest Way

I have a table Entries with these columns [RACE_DATE], [RACE_NO], [HORSE_NO], [HORSE_NAME]
I have other Table Horses with these columns [HORSE_NAME] , [SIRE], [DAM], [TRAINER]
As you can see this to tables are linked or reference by the column or field [HORSE_NAME]

What would be the easiest way to create a virtual column in the Table Entries or a Slice View of Entries bringing the data columns for example [SIRE] and [DAM]?

I have seen LOOKUP, ANY, SELECT expressions and seems a bit code tricky!

Assuming Entries table references Horses table, please take a look at the dereference expression


Thank you.

1 Like