Hello is it possible to link tables by few condtions?
I have 4 tables:
I linked Budget and transaction each with both Reporting period and category
Now I would like to see summary of transactions against budget per month and category
currently both tables contains this two field but I dont really know how to actually link without creating another field and links is it possible at all? Its like I want to link tables based on condition from another link table
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:)
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 and each transactions is mapped to category and month.
Now question i how to see sum of of transactions for each records(category month comibnation ) in Budget table?