I have created a table to store monthly forecasts and a form for the user to enter the details
Details entered like this where the first line is the column header
Line Item, month1, month2, month3, Total
PC, £5000, £1500
Desks, £3000, £2000
Stationery, £50, £50, £50
As the user will be changing this data regularly, i've set up a basic form to make this a little easier.
What i'd like to be able to do is show the total in the form AND then updated back in the table
Details entered like this where the first line is the column header
Line Item, month1, month2, month3, Total
PC, £5000, £1500
Desks, £3000, £2000
Stationery, £50, £50, £50
As the user will be changing this data regularly, i've set up a basic form to make this a little easier.
What i'd like to be able to do is show the total in the form AND then updated back in the table