# Question on 'joining' tables!

**URL:** <https://community.fibery.io/t/question-on-joining-tables/5350>\
**Category:** Get Help\
**Created:** [October 31, 2023, 9:20pm UTC](https://community.fibery.io/t/question-on-joining-tables/5350 "2023-10-31T21:20:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![morganf](https://avatars.discourse-cdn.com/v4/letter/m/f4b2a3/32.png) [@morganf](https://community.fibery.io/u/morganf)\
**Post date:** [October 31, 2023, 9:20pm UTC](https://community.fibery.io/t/question-on-joining-tables/5350/1 "2023-10-31T21:20:10Z")

</div>

Hey guys!

Okay I’m trying to do something in Fibery and I’m running into a challenge. Maybe someone can help me? I’d appreciate it!

I’m trying to track the finances of a tiny non-profit. I have one Fibery database that lists the donors. Another that lists every transaction (every time we receive a donation), like a transaction history. And I have a third one that lists their promises (we’ll have a campaign where someone promises to donate $100/month for one year; it’s structured as a promise number, and you can choose a single select for which campaign it is, and then in the other database of the transactions, I have a single select to list the campaign (so theoretically I can match up the campaigns). (Is this the right way to set it up? Let me know if you have a better idea!)

I’m looking to create a report, table, or list, where I can just take one campaign (which is a single select in both the transactions table, and the donation promises table), and for each campaign (the select options) see the list of people who made promises, and the total that they contributed towards the promise.

Any guidance on how to go about doing this?

Thank you 🙂 morgan

---

<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 31, 2023, 10:48pm UTC](https://community.fibery.io/t/question-on-joining-tables/5350/2 "2023-10-31T22:48:19Z")

</div>

On first reading, it sounds like Campaign should be a database of its own, which links to Transaction and Promise databases (one-to-many) so it behaves like a single-select which they both can link to.  
Then you can just open an Campaign entity and see what the linked Promises and Transactions were, as well as a load of other options for views and reports.

---

<div class="post-metadata">

**Author:** ![morganf](https://avatars.discourse-cdn.com/v4/letter/m/f4b2a3/32.png) [@morganf](https://community.fibery.io/u/morganf)\
**Post date:** [November 2, 2023, 12:49pm UTC](https://community.fibery.io/t/question-on-joining-tables/5350/3 "2023-11-02T12:49:18Z")

</div>

OMG - Chris - that was perfect! Exactly the right structure! You guys are awesome, thank you 🙂