Neil,
I just finished creating a model which symbolizes SMH Inspections based on when the inspection was entered into the related table. It is based on a field in the SMH Feature, exactly like what Randy was talking about above, but joined to the Inspection Table and run using a Python script in Windows Task Scheduler. I populate that field with a "Yes" to indicate it was inspected within the last month (Green Diamond), which is hidden and not editable by field staff. When a month elapses, the yes will change back to <Null> and the symbology will change back to a Red Diamond.
This is the basic outline:
The first 4 tools clear any of the existing "Yes"(s) in the Feature Class and allow it to be populated with the most recent data.
You then join the SMH Inspection FC and the Inspection Table. You MUST make the FC a Table View first however, or the tool will not run when called in Python.
The Inspection Table must be made into a Query Table so you can pull the records within the last month. Here's what that looks like:
Make sure to enter in the time you want in the Expression. I will ultimately use the 'created_date' field. This will pull all records in the last 30 days.
Then Join to the FC Table View and keep only matching records.
Field Calculate the designated field in the FC with a value (Yes for me)
Remove the Join.
In order to get this to run automatically, open IDLE and enter the following:
import arcpy
arcpy.ImportToolbox("C:\Users\USER NAME\AppData\Roaming\ESRI\Desktop10.5\ArcCatalog\DATABASE NAME.sde\TOOLBOX NAME (do not include .tbx)")
arcpy.ToolboxALIAS.ModelName("C:\Users\USER NAME\AppData\Roaming\ESRI\Desktop10.5\ArcCatalog\DATABASE NAME.sde\FEATURE CLASS NAME")
print "Completed"
Run at your convenience with Windows Task Scheduler.
I know this is more than what you want so you can definitely eliminate the time part of it if you just want to see that it was inspected at some point. I just put this all together since others may find it useful and I literally just finished it so it's still fresh in my mind.
Fred