I am trying to create a cashflow system for projects which all have varying time frames. Each project will have its own project ID and a cashflow table, the cash flow table has a record for each month of the project with the following fields:
3) Profit for month (calculation of income - expenditure)
4) Balance (carried forward from previous month with profit or loss added)
I would like this to work without having to run a script to recalculate the table if changes are made. I cannot see a way to do this without a script though.
Does anyone have any suggestions?
Thanks in advance