compute last date and put in new table?
I'm monitoring a list of properties for security violations. We have a 'monitorings' table where we record each violation with date. I want to include the date of the most recent violation in the 'P...
Forum Discussion
Hopefully you have a relationship where One Property has Many Monitorings.
Just go into that Relationship and on the left side there will be a button to set up a summary field. Make it the Maximum of the Date, possibly subject to the filter that the [Type] was "Violation".
Just go into that Relationship and on the left side there will be a button to set up a summary field. Make it the Maximum of the Date, possibly subject to the filter that the [Type] was "Violation".