Defining something other than what is assigned

[nevilledhamsiri]

Dear All

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?

Using a set expression? etc

Thanks

ME_CODE

07184       

07556      

01555

03525

[Brett_Bleess]

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.

Regards,
Brett