Looking for a Better Idea
I have 120 records in a CR field , for each record in CR field there is a corrosponding Value from a VL field which get selected in a Record . The value selection from the VL field is done automatically based on records selected in CR field through Custom Object . But the current problem is , if we select 2 records in CR , 2 values shown from VL field , but remaining 118 values also display from other VL fields.
Our requirement is to hide this 118 Values from other VL fields , as only 2 Values should be shown based on 2 Records selected in CR field.
If we want to achieve it normal staff , we may have to write 100 DDES to display & hide , so I am looking for a better idea , how can this be synthesized in a good way ?
I'm not sure I'm fully visualizing what you're doing, but what if you do it the other way around? Select the VL field and then have a calculated CR based on the VL selection? bonus, it eliminates the custom object.
Understood , but actually the design has been setup this way and possibly at this stage its not possible to change . so main criteria will be to supress the other VL fields , and to show only VL fields , for which same value has been selected in CR field .
I was thinking could be something other , rather then writing numerous DDES ?