# Multiple Views for to-many relations Question

**URL:** <https://community.fibery.io/t/multiple-views-for-to-many-relations-question/3418>\
**Category:** Get Help\
**Created:** [October 19, 2022, 4:52pm UTC](https://community.fibery.io/t/multiple-views-for-to-many-relations-question/3418 "2022-10-19T16:52:59Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![cssrctech](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/cssrctech/32/5154_2.png) [@cssrctech](https://community.fibery.io/u/cssrctech)\
**Post date:** [October 19, 2022, 4:52pm UTC](https://community.fibery.io/t/multiple-views-for-to-many-relations-question/3418/1 "2022-10-19T16:52:59Z")

</div>

Hello,

I’m attempting to create a list view for Donations underneath a Contact that shows the total for Funds that someone has donated to.

Relations:  
Contact \> one to many \>\> Donations  
Donations \>\> many to many \>\> Funds

When I change the first level to Funds and the second level to Donations under the contact’s entity view, it filters down to the Funds they have contributed to but shows Donations from all Contacts (somewhat confusing to an end user).

I understand there is no direct relationship from Contact to Fund. I added a lookup via Donations, but no view capability exists on the entity for lookups. That lookup doesn’t give me the ability to automatically link Contact to Fund when attempting to create a new relation between those two. How can I achieve a Fund summary view on the Contact? Is my structure out of line to achieve this without using a Report? I did create a report, where I found a separate issue: when printing the report, it prints all records versus the filtered ones.

I know I could go Contact \>\> Fund \>\> Donation, but that’s not how I want the data structure.

Thank you!

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [October 19, 2022, 5:38pm UTC](https://community.fibery.io/t/multiple-views-for-to-many-relations-question/3418/2 "2022-10-19T17:38:23Z")

</div>

It’s true that the context filter does not apply to the second level, as you are discovering.

> [@cssrctech](#):
>
> How can I achieve a Fund summary view on the Contact?

A relation report view (instead of a relation list view) should get you something close to what you need.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/3/36adebfab0e6151e8536c11c3ff3cc6c5f7d7b44.png)

> [@cssrctech](#):
>
> I did create a report, where I found a separate issue: when printing the report, it prints all records versus the filtered ones.

Perhaps you can give us some more details - sounds like a bug.

---

<div class="post-metadata">

**Author:** ![cssrctech](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/cssrctech/32/5154_2.png) [@cssrctech](https://community.fibery.io/u/cssrctech)\
**Post date:** [October 19, 2022, 6:00pm UTC](https://community.fibery.io/t/multiple-views-for-to-many-relations-question/3418/3 "2022-10-19T18:00:19Z")

</div>

Thanks, Chris, for clearing that up! The report image you sent is (almost) identical to what mine looks like. 🙂

![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/6/608331b9ce3412cd3a6385de931e07421f66a3cc.png)

When I click on the three dots and hit Print  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/5/5a0b4d2d386c453800fa4c5de07e6268cb3504f4.png)

I get this (a snippet):

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/7/7638c639cbda4dacf125783bcd40a1fb9437fe09.png)

If this needs to be separate let me know, but when exporting to a PNG or printing it doesn’t respect the customized column widths. I’ve experienced this PNG export issue prior to the Relations Reports, just forgot about it until now.

Thanks!

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [October 19, 2022, 6:14pm UTC](https://community.fibery.io/t/multiple-views-for-to-many-relations-question/3418/4 "2022-10-19T18:14:01Z")

</div>

Looks like a couple of bugs there.  
I’ll ask the devs to Investigate.

---

<div class="post-metadata">

**Author:** ![cssrctech](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/cssrctech/32/5154_2.png) [@cssrctech](https://community.fibery.io/u/cssrctech)\
**Post date:** [October 19, 2022, 6:34pm UTC](https://community.fibery.io/t/multiple-views-for-to-many-relations-question/3418/5 "2022-10-19T18:34:01Z")

</div>

Amazing. Thanks again!
