Pretty new to this so excuse me!
I'm having trouble updating a column in table1, with the sum of the column in table 2. Field in table1. and then have another field in table 1 that is updated using the new data. With the goal being, we can see what is being spent, and how much of our budget we have left.
Table 1 contains the data of a project including a budget information. The field that needs updating is the 'Budget Remaining' field. The data in table 2 contains information on expenditure, purchases etc. I have a field in table1 that I would like to have values updated when the fields in table 2 are updated by users.
Then I would like the total spend to be taken away from the budget, to leave the budget remaining. Because of the application that's uses the data, we need to have the data on separate tables. The column that is to be updated, will need to be repeated for every record, so that the application shows this when users select a record
Any help or advice would be much appreciated!