I am trying to find a solution to the following and haven't been able to find any help articles on it.

In a table called Client I have a field called Total.  

I have a table called OpenItems with a field called Value

I would like the Total field to be the sum of the Value field when the ClientID field matches.

Any help on completing this would be appreciated.

Many thanks.

Best regards

John MacPherson
www.saffuze.com