Totalling values in a linked form
I've created a small Job database with two forms; 1=Client form, 2=Job form.
The Job form has a lookup field linking the Job to the Client. The Job form also has a field for the value £ of the Job.
I want to be able to have a field on the Client form that totals the value of all linked jobs.
Can you advise the best way to do this?
Thanks,
Martyn
martynhale