I have a Contact record that I need to be able to show the corporate group structure from any Contact record.
Code: Select all
Head
⊦ Level 2
⊦ Level 3
⊦ Level 4
psParent
psGroupHead
If a psParent changes to another group then I need to filter that to all of the pmSubsidiaries.
My plan was to run a process passing the Contact being edited then
FIND Contacts WHERE Contacts.psParent=The Contact being edited.
Is the Contact being edited ThisContact or ThatContact?
When the FIND completes I will have a mixture of Contacts where Contact.psParent=the edited Contact. How do I refer to them?
I am trying to keep things out of the LoggedInRegularUser as I have quite heavy (wide) BOs and I am already using this a lot.
ps This and That are impossible to search in here...