Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

RELATED function not working in one to many relationship

HI ALL   I have two Tables  Registration Table and Interview Result Table.    I want to create two columns (Final Status, Interview Completed?) in the Registration Table by using Interview Result...
Need Help
  • Stachu's avatar
    Stachu
    7 years ago

    RELATED works only for side 1 of the relationship, for side many you need to use RELATEDTABLE

    Column = LASTNONBLANK(SELECTCOLUMNS(RELATEDTABLE('Interview Result'),"Status",[Final Status]),TRUE())
Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
7 years ago

RELATED works only for side 1 of the relationship, for side many you need to use RELATEDTABLE

Column = LASTNONBLANK(SELECTCOLUMNS(RELATEDTABLE('Interview Result'),"Status",[Final Status]),TRUE())