trying to store latest revision on a HEADER record from multiple rows (each with an ascending revision) in the same table. The first row far right on HDR should be the max of 4 shown below. currently says 0.

Have two views - HEADERS ONLY and REVS ONLY - so created a link to another record to use rollup.
When there is a new revision in the REVS ONLY VIEW - I try to fire an automation that detects the new rev, and automatically copies the ME35 number into the field I use for the link….


argghh…..does not want to work !!!! Ideas ???
Many Thanks Mike