Changing Modified Date of Parent from Child

[pablo_tx]

I have a bit of a problem. I have a relationship where I am trying to detect whether a child was modified through the parent.

Kit (parent)

KitID

KitDescription

CreatedOn

ModifiedOn

Component (child)

ComponentID

ComponentDesc

KitID

ModifiedOn

In this example I can have an established parent and say 3 children. Through a nightly process a child may be either added or removed. If I were to run a search for records modified I would want to pull up the parent that was modified via its children.

Any ideas how I would set this up?

[comment]

A parent record is NOT modified via its children (or vice versa). You can have a calculation in the parent showing the last time a child was edited or added - but not deleted.