Need to copy fields from the most recent child record into the parent record.

We have a capital asset management application with a parent table Surface Lots and child table Documents. Each year, one of the documents placed in the Document table for each of the 179 Surface Lot...