Hi there! We put all of our inspections into a related table, so you have a setup like this>>
ssGravityMains (IDs, d/s manhole, last date tv'd, total pipe length, etc..)
|__related inspection table (IDs, date TV'd, LENGTH TV'd on this date, etc..)
Do the relate on the ID's. As of right now our field crews are having to manually fill in the "Last TV date", but we're working on some scripting solutions so that portion will auto fill with the most recent date.
-David