Common Department in 1 List
I would like to ask a question in my new setup where I can flag similar departments in a list. Using only the 3 letters of the code present on the list. In my example below there is 2 Office of the President 1 which is the child of the TMC Main parent and the other is the child of TMC SL.
Requirement: I need to flag both Department using only the 3 letters of the code as their difference. It will flag bother Office of the President and CEO but only the one under TMC main will have a true on the Boolean. I will do this all through out the list. Whether there is an Office of the president on a new entity TMCI or TMC Iloilo. Then these departments will then be imported to a new list (not clear yet why – but for the sake of requirement). I only use as an example the office of the president there will be other departments like laboratory and pharmacy that will be common to all Entity Hospital on the list. I re-created this on a sample model first before I transfer to the actual model. The Only difference between TMC Main and TMC SL is that departments in TMC SL has an extension of _SL at the end. Same with other entities. Also if you can include the next part where I can compile the common departments to be imported to a new list. I would greatly appreciate it.
Thank you in advance,