Hi! I am interested in feedback on how to achieve this use-case.

People (Clients, with relationship fields like “Executive” or “Administrator”)

Subsidiaries

Parent Accounts

Subsidiaries are linked to Parent Accounts.

People are currently linked to Subsidiaries. For People records, a Lookup field automatically populates the Parent Account based on link between Parent Account and Subsidiary.

Goal: I would like to be able to see a list of all my “Executive” People that roll up to a Parent Account.

(I could manually link People to Parent Accounts, but it seems redundant since we already have them linked to the Subsidiary).

Thank you in advance for your feedback!