Is there a way to show a report from a parent on a child's form?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

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?

Photo of Rob

Rob

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
A report link field is just a way to show a Report on a form. There does not need to be a relationship. The report does not even be from the same app.

So, .....
You know that the report link field's right hand side configuration is the field for Related Project Registration. So you just need to coax the field for the most recent Project Regustration Record ID up to the Project and use it to configure the Left field of the Report Link field.
Photo of Rob

Rob

  • 0 Points
Thank you for the help. It was a little tricky because I'm very new to quickbase and all previous report links had been auto-generated for me, I didn't realize where the information for what was being linked was stored and was never going to the actual settings tab of the report link, just the actual reports that were being output and trying to figure it out in there.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
So you got it working?
Photo of Rob

Rob

  • 0 Points
Yes, thank you for the help