i have a field DT_TYPE in which the following data is given
in my dashboard i want to provide following option under DT_TYPE
NDF & NDR
such that when NDF is selected only defect type related to NDF is shown and when NDR is selected only NDR related data is shown and when NDF & NDR is selected then all type of NDF and NDR should shown....
according to your suggestion DT_TYPE2 will take only NDF , NDR what about NDF-absolute, NDF-Test.....
DT_TYPE2 should contain only three values NDF, NDR and NDF&NDR when user select NDF then data should be related to NDF and if it is NDR then data should be related to NDR only... and if User select NDF and NDR then data should be related to all type of NDF (i.e NDF+NDF-absolute+NDF-Test.....+NDR) and NDR
it's just a function to select a set number of characters from the left side of your field, so in this case just the first 3 which you are interested in, you then left your true statement too so that 'NDF - test' for example just becomes 'NDF' in your new field allowing you have all the NDF types under that one name in your new field