So I know that when someone asks about how to combine two tables into one, usually the answer is “You should instead first create a master table, and then split it into multiple views.” But what about when the tables I want to combine have very different schemas?
Here’s a simplified version of my problem:
- I have a Donations table
- I have an Expenses table
I want to track how we are doing, over time, in terms of both donations and expenses for each budget category every month and every year. I could combine donations and expenses into one table (eg, “Transactions”) but then I would have so many empty columns in each (and the more complex version has more tables that I want to combine).
I am leaning towards a different option right now: make a button that pulls in rows from Donations and Expenses into a third table (eg, “Budget Lines”) and then integrate only that one with my Budget table for analysis and charts and whatnot.
Any tips from the community? (I’m also not a finance person, so maybe I may very well be missing something obvious from that area of expertise.)