Skip to main content

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!

Reply