I have Three tables that are linked. Project, Project Registration, and Members Registration. A Project Registration includes many Member Registrations which correspond to the 'roster' of who is working on the project. A Project can have multiple Project Registrations that correspond to different iterations of a team that is working on a project.
I have a reverse relationship set up between Projects and Project Registrations so that I can get the most up-to-date information about the project to surface, such as the number of members, current status, etc.
I would like to be able to also surface the most recent Member Registrations on the Project as well. I can lookup all of the fields except the Members Registration report link. In the reverse relationship, is there a way to do a lookup of the Member Registrations report?