How to distribute amounts
I got a table (say table1) with a percentage field. All rows in that table add up to 100%. There is also an amount field set to 0 initially.
In another table (table2) I create rows and amounts. I want those amounts to be distributed over table1:amount.
Now after adding amount 500 to table2, it should be distributed to table1:
Now the reason why I can't use calculated fields: The percentages can change. But the amounts that have been distributed may not change!
When another row is added to table2, that amount should be added to the existing amounts in table1, using the new percentages in table1:
Is this possible at all with FMP?