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

[yastaaa]

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!

[Suvrutt_Gurjar · Accepted solution]

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

help.appsheet.com

Dereference Expressions

Use a dereference expression to get a column value from the referenced row.

[yastaaa]

Thank you.