Skip to main content

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

argghh…..does not want to work !!!! Ideas ???

 

Many Thanks    Mike

 

Hm, could you create a simplified example base as well as step by step examples of input and output?  Would love to help but don’t understand the workflow well enough, sorry!


 

Hi Adam….here is the problem ...what I want to do is get the max of REV on rows 2-6 and maintain the highest automatically in either REV on row 1 (HDR) - or - in LATEST CHANGE ORDER on row 1.

I did a link back to this table itself in BUY on a VIEW called HEADERS ONLY.

here is the rollup on LATEST CHANGE ORDER

 

it does not work….and if it did….then I have to build an automation to place a copy of ID into BUY every time someone adds a new REV (the users will not do it) using a when record enters a view (CHANGE ORDERS)….and that does not work either….HMMM…..

 

ANY HELP GRATEFULLY RECEIVED !!!!   MIKE


Hmm..how do records get created in this table?  Are all the records that get created going to be REV records?

Wondering whether you might be better served with a table for ‘Header’ type records and another table with ‘Rev’ type, and then linking the two together and getting the latest revision via a Count field and instead


Reply