I have an app with this table structure:
Parent 1 < Child > Parent 2 > Gparent > GGparent
In some instances the GGparent doesn't exist, just the Gparent.
In the Parent 1 tables, we want a summary fields which list all unique values for Children, but many children come from the same GGparent or Gparent.
Here's what I mean: We want a summary field that lists which of our Consultants work with clients that a contact works with, without listing the same Consultants twice. In this instance:
Contacts < Trust Roles > Clients < Client Assignments > Consultants
Another example, we want a field which lists the Provider-type Trust Roles that a Client has, without listing the same Provider-type Company twice:
Clients < (Provider) Trust Roles > Contacts > Locations > (Provider) Companies
I can establish the reverse relationships and summary fields, but I'm not sure how to make sure the summary fields filter for unique values. It'd be great if there was a way to filter the uniqueness of the values such that we'd need less reverse-relationships to accommodate them.