Updating Value in a Parent Object which is the Total of Child Reference Records

Often we are presented with a situation whereby we need so see an updated Total of child reference records on a Parent form. For example, the Total Value of Order Lines in a Purchase Order and / or a count of the number of Order Lines.

This BSV demonstrates how to achieve this functionality and to ensure the Form / Query refreshing is done properly.