My custom personal CRM is composed of 3 tables: People, Organizations, Interactions.  People belong to one or more organization.  Interactions are individual events that could include multiple people.  Organizations has a linked field to People.

What I want to do is show when the last time I interacted with each organization on the Organization table.  I figured out how to show the last time I interacted with a person using a Rollup with the Aggregation formula of MAX(values).  Now how do I go through and aggregate each persons last interaction to show the latest for the organization?

Thanks, Jon