What Table Should I Report From?

Question

I'm trying to determine the best way to report the following. Assuming there's a way to report at the higher level and get the results in an easier way.&nbsp;Do I need to pull all the info down to the 'applicant' level table or is there an easy way to keep the one-way table structure and report higher up?Table StructureProperty-Units--Applications---ApplicantsThe goal is to pull a report that includes a line by line of all applicants that are associated with a unit.&nbsp;Example: Unit 202 has 1 applicant associated, Unit 203 has none, Unit 204 has two applicants and Unit 205 has 1 applicant associated(Standard Table Report Layout) There are more fields needed/crossing over, but this should paint the picture.&nbsp;Where each field originates:Property - PropertyUnit - Unit &amp; StatusApplication - Lease Start Date &amp; Lease End DateApplicant - Name, DOB, Gender, Income,&nbsp;Property&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Unit&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Status&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DOB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Gender&nbsp; &nbsp; Income&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Lease Start Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Lease End Date&nbsp; &nbsp;Prop A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;202&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Rented&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jim Jon&nbsp; &nbsp; &nbsp; 3/3/1980&nbsp; &nbsp; Male&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$80,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9/9/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9/8/2020Prop A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;203&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Available&nbsp; &nbsp; &nbsp; -----&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;-----&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-----&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-----&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-----&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;-----Prop A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;204&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;In Process&nbsp; &nbsp; An Poi&nbsp; &nbsp; &nbsp; &nbsp; 3/3/1982&nbsp; &nbsp; Female&nbsp; &nbsp; &nbsp;$110,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10/9/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10/8/2020Prop A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;204&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;In Process&nbsp; &nbsp; Tom Poi&nbsp; &nbsp; &nbsp; 1/3/1979&nbsp; &nbsp; Male&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$90,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10/9/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10/8/2020Prop A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;205&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Rented&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Ed Inn&nbsp; &nbsp; &nbsp; &nbsp; 7/3/1984&nbsp; &nbsp; &nbsp;Male&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$75,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9/18/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9/17/2020Thank You!------------------------------Chris------------------------------

markshnier__you · Answer

The simplest way is to make your report off the most detailed level, so the bottom Applicants level. You may be able to use a Summary report to avoid repetition that you would get using a table report with Group By. But try both approaches. Maybe it will look best using as table report with Group By and not repeating all the columns which are in the Group By.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

chrisfaye1 · Answer

Figured, but was hoping for some funky trick :) Thanks, Mark!------------------------------Chris------------------------------

Forum Discussion

What Table Should I Report From?

Related Content

Building a report from multiple tables

Multiple Tables Report

Summary Reports

Report Formulas

Table is missing