I have 2 lists
In Positions, I create a position, and assign it a candidate and then a status (New, Rejected, Approved, etc). This part is all good.
The challenge I have now is that under the Candidates profile (a selected candidate from a list) I want to show a list or history of all positions that the candidate has been assigned to, and it's current status.
I am currently using SharePoint 2013 and SharePoint Designer 2013. I am assuming a lot of this logic will happen in designer for the 'DispForm.aspx' file.
I guess what I want to do is get all 'Positions' items, find all the objects who is assigned to currently selected candidate object, and display in a list type result along with the status field.
Best way to do it?