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
