Retrieve main table data

I want to retrieve the value Since I have 2 tables (main table, secondary table)
For example,

The main table (MD) has the following columns:
- ID_MD
- Model_MD


The secondary table (Daily1) has the following columns:
- ID_MainDaily connects the ID to the MD table.
- Machine
- Model

That is, I want the Model of the child table (Daily1) to fetch the value in Model_MD of the main table (MD).
I got this recipe from Marc_Dillon.
LINKTOFILTEREDVIEW( Servers_table , [sector]=[_THISROW] ) I followed this formula. It's a random message displayed.

0 2 104
2 REPLIES 2

It sounds you are looking for a dereference. Something like [ID_MD].[Model_MD].

Yes, but I want that.
Master table (MD)
ID_MD = YSR125
Model_MD = test model

Secondary table (Daily1)
ID_MainDaily connects the ID to the matching ID MD table.
When ID_MainDaily matches ID_MD, model_MD must be retrieved.

Top Labels in this Space