# Multiple Relation for Reports

**URL:** <https://community.glideapps.com/t/multiple-relation-for-reports/62128>\
**Category:** Ask for Help\
**Created:** [May 25, 2023, 8:35am UTC](https://community.glideapps.com/t/multiple-relation-for-reports/62128 "2023-05-25T08:35:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)\
**Post date:** [May 25, 2023, 8:35am UTC](https://community.glideapps.com/t/multiple-relation-for-reports/62128/1 "2023-05-25T08:35:14Z")

</div>

Hello, Heres My Case:

I Got a List of Property  
i want to know how much each property earned each month in a year.

how do i get that ?

Table1 : list of customer with certain property they bought  
Table2 : list of property name  
Table3 : list of month (from jan-dec), and i can insert each month target goals so i could compare against the realize from Table1

The Result would be:

When in May, I Could have a graphic of

Jan-May target compared to Jan-May Realize

would it be possible ?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [May 26, 2023, 12:04am UTC](https://community.glideapps.com/t/multiple-relation-for-reports/62128/2 "2023-05-26T00:04:45Z")

</div>

Can you show us the data structure of table 1? Would that include the price that the customer brought the property at? I think this is a permanent purchase, not a monthly rent, is that correct?

---

<div class="post-metadata">

**Author:** ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)\
**Post date:** [May 26, 2023, 1:56am UTC](https://community.glideapps.com/t/multiple-relation-for-reports/62128/3 "2023-05-26T01:56:01Z")

</div>

Yep. Permanent Purchase

Table 1:  
Customer | Property Name | Price | Bought Date

Table 2:  
List of Property Name

Table 3:  
Month of Year