Is it possible to create a property that totals values from related objects?

We have two objects - Monthly Timesheet and Timesheet Record, the later being a subtype of the first.

Both objects have a number property - Monthly Total and Total Hours respectively.

The Monthly timesheet will have multiple timesheet records added to it and I want the Monthly total, on the Monthly Timesheet, to add up each of the Timesheet Records total hours.  Both properties types are Number (real).

My thinking was to make the Monthly total property, a calculated property using VBScript but I am useless at creating VBScript. 

The other thought was using Managed Properties in the Compliance kit but I haven't been able to achieve that as yet.

I could really do with another pair of eyes, any help would be much appreciated.

Thanks in advance Blush

K

Parents Reply Children
No Data