Hello everyone. I'm trying to source a drop down list of contacts on an Opportunity record, these are supposed to be all contacts of the company that is selected. Right now, I can easily filter the list by the Contacts of the Company selected on the Opportunity, or filter by the Company's parent Contacts.
But what I need to do is list all of the contacts for the Company and all of the company's parents' contacts, even for 3rd+ level hierarchy.
Ex. If I had Company3 selected on the record with this hierarchy: Company1->Company2->Company3->Company4, I would like to show all contacts from Company1, Company2, and Company3.
If this can be done in the UI, then great! But if not, I'm not exactly sure how to do this in scripting then, especially getting it to behave the same way as the sourced list works, which would be nice.
Any help is appreciated.