Sum of Values from a Field
I am building a database for which it is possible to have multiple payments for a single job (deposit, Final payment) I have created a payment database and a job database, so when you make a payment it is recorded against that job, what I would now like to do is add all the payments for that job together and show them in a new field ie total payments.
It would also be good to be able to show in another field payment amount remaining ie Total cost - payments made
not quite sure where to start with this. currently I have all the payments made for a particular job showing up in the portal against that particular job see image
Thanks for any help
Worked out the answer myself, I just needed to make the total paid field a summary!
Hope that was right anyway!