Need Last Primary, Secondary and Tertiary Approver in Parent Table

I need to get the latest (max) approvers from a Status Log child table into the parent JE table to facilitate monthly reporting.  There are 3 approval/approver levels: 1) Primary, 2) Secondary and 3) ...