Hi,
In our database we have John Smith and he could have 5 different codes.
John Smith - EP Former, EP Parent, Outreach Parent, Former Parent, Parent
I need to create buckets for each 5 codes. I wanted to create a hierachy -
(in this exact order)
1. Parent, 2. Former Parent, 3. Outreach Parent, 4. EP Parent, 5. EP Former Parent.
Where ever the code falls in the system I want to put in the correct bucket by hierachy. Also, if anyone is ever coded Former Parent and Parent they automatically get pulled into the Former Parent bucket.
Any help would be greatly appreciated.
Thank you
EmPaige