Linking vs. Look-up for People vs. Subsidiary vs. Parent Account

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!

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.