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!