I have a table called 'Project_Details' with two ocurrences ('Project_Details' and 'Project_Details 2') linked by the 'project_Id'. I have a layout called 'Project Details Layout' where the user cand go through the different projects. I have also added a portal that shows all related projects.
What I want to do is when the user moves through a record, it should go to a different projectid. When I am looking at a project id, which can have multiple of the of the same, I want the portal to show all of the the related project ids. But when I move to the next record on top, I do not want to see the same project id (projectId01), I want to see the next one (projectId02).
Note: I do not have the 'projectId' field set as unique ( I do not want to, because I wil need it this way for something esle). There are multiple projectids with the same value (I want this).
Hopefully this makes sense.