Hello is it possible to link tables by few condtions?
My Example:
I have 4 tables:
Transactions
Budget
Reporting period
Category
I linked Budget and transaction each with both Reporting period and category
Now I would like to see summary of transacti...
sorry I didn`t explain this to well so
I got tables with Categories(5 records) and Month(2 records) - for grouping
Next there is table with budgets and each category has budget in each month so 10 records here
and last there is transactions table a...
to be more clear:
I want to
add budget for each category and month combination
then add transactions with month and category
and at the end to see and monitor monthly results budget vs spend per category:)
