Hi, I need some help regarding forms and metadata.
So I have 3 Tables: Primary Table (PT), Secondary Table (PT) and a Relationship Table (RT), in this table there are created relationships between PT and ST.
PT has Projects, ST has Subprograms, a Project can be part of multiple Subprograms (when a relationship like that is created, it is stored in the RT).
In the Portal I have a list made from PT, in this list I have projects, I am able to view the details of this Projects, and when viewing the details, I also can view the relationships that project have with Subprograms, (here I am basically viewing the relationship that is created in the RT table between PT and ST), now in this relationship I have the Name of the Project and the Name of the Subprogram, what I want from here is to be able to view details for the Subprogram (to do that I will have to somehow link the name of the Subprogram found in the RT with the name of the Subprogram found in ST, and when viewing the details, I would view the Subprogram details that is found in ST). I can`t get it to work, have no idea how to do this. Any help please?

Report
All responses (
Answers (