May 08, 2020 11:55 AM
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
May 08, 2020 12:12 PM
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:)
May 09, 2020 10:56 AM
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.
May 10, 2020 02:34 AM
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?
May 10, 2020 02:45 AM
You have to have linked fields then use rollups.
So you hve to link the tables together using Link to another record. What is the common item between the tables and what is the item you want to rollup by?
Make screenshots so I can understand it better