cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vengadeshpalani Regular Visitor
Regular Visitor

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 Table value

 

How can I achieve this logic?

 

Registration Table:

 

Candidate ID Name Phone

1A5555555
2B6666666
3C7777777
4D888888
5E999999

 

Interview Result Table :

 

Candidate ID Interview Round Status Final Status

1Tech 1SelectedSelected
1Tech 2SelectedSelected
1HRSelectedSelected
1FinalSelectedSelected
2Tech 1SelectedRejected
2Tech 2SelectedRejected
2HRSelectedRejected
2FinalRejectedRejected
3Tech 1SelectedHold
3Tech 2SelectedHold
3HRHoldHold

 

Final Result:

 

Candidate ID Name Phone Final Status Interview Completed?

1A5555555SelectedYes
2B6666666RejectedYes
3C7777777RejectedYes
4D888888 No
5E999999 No
1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: RELATED function not working in one to many relationship

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())
1 REPLY 1
Super User
Super User

Re: RELATED function not working in one to many relationship

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())