last table modified

[rivet]

I have one table with several related tables. When and edit is made in the main or related tables, I would like to know which table has the most recent modification to it.

To get the mod date or time I am using the Max function. The challenge is getting the 'max' user.

[comment]

If you sort your relationship by ModificationDate, you can get data from the last modified record either directly (if sorted descending), or by using the Last() function (if sorted ascending).

Or use a calculation field =

Case ( ModificationDate = Parent::MaxChildModDate ; ModifiedBy )

and get the data into the Parent using the List() function. Note that there is a possibility of a tie, returning more than one name.

[rivet]

That worked great. Thanks