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 don
t 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
Im honestly a bit lost in your question but I will try to answer what I understand.
First, if you want to Link tables, then you have to Link them :grinning_face_with_big_eyes: This means you create a new field and link them accordingly.
HOWEVER, I think what you are looking for is Conditional Rollups. You can rollup the fields based on Conditions.
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?