Forum Discussion
Create relationships using dates
Hello, I have two tables that I want to relate. The two tables have the same fields but one is for incomes and the other is for expenses correponding to the same year. I would like to relate the two ...
ImkeF
Community Champion
Community ChampionI would recommend to append both tables instead. But before you do that, add a column called "Source" to your income table with "income" and the same with "expense" for your expenses table.
That way you just have one date-column and both values will be filters simultaneously.
Drag the field "Source" into your report in order to distinguish between both values.
ImkeFCommunity Champion
Community ChampionOtherwise you would have to create a calendar/date-table to combine both tables on its date-field.