Hi,

I am trying to find a process where I can display 2nd field value when I type in mix case value in a 1st field (String Type). Hope someone might have already done this similar scenario or might know how to do it. Your help would be greatly appreciated.

Scenario:

I have a 1st field called "Customer" (String Type field) and 2nd field called "Market" (look up list type field). Now, for Produce and Market field I have hard coded in workflow as follow:

If FieldName= "BG_USER_01" Then ‘CUSTOMER

Select Case Bug_Fields(FieldName).Value

Case "salex" _

Bug_Fields("BG_ USER_02").Value = "local" ‘MARKET

End Select

End If

Note: I choose to do with case statement cause I have several customers and Market list.

In my above code I would like to implement mix case condition. When I have mix case, I do not have to worry how I type in about customer First name initial and complete last name.

Now, When I type in Customer's First name initial and complete last name example: salex or SAlex or Salex in "Customer" field, I should get correct value in my 2nd field which is "Market". The correct value for Market in this case is "local".

So, how I can set up upper-case or lower-case ignorance condition to satisfy my scenario? Please advise.