If I have 30 to 50 codes such as below of which dimension being ME_CODE & If I need to define 07184 , 07556 & 01555 as branch heads where as all other codes are to be assigned with clerk what are the options available.
If the where clause is used how it could be done?
If this is done in the script just below the relevant field, how it should be made?
I am afraid you are going to have to provide a bit more information to get a response on this, nobody really has enough background information to even try to respond currently, so please leave an update with a more thorough description of the use case and a data model or sample app would be even better. You can use the Settings\Document Properties\Scrambling tab to scramble any sensitive field information. Without this, I doubt you will receive any further responses.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.