3 Replies Latest reply: Jul 29, 2013 5:53 AM by Uday Kumar G S RSS

    Find common values in a field based on other field

      Hi,

       

      I have two fields, consider field1 and field2.

      Field1 has two values 0 and 1.

      Field2 has values like A,B,C,D,E,F,G.

       

      These two fields are related to each other, if i select 0 from field1, it will filter A,B,C,D.

      if i select 1 from field1, it will filter everything in field2 means A,B,C,D,E,F,G.

      Now i want to get the common values between these selections. i.e., A,B,C,D

      i want to get the common values in other listbox which should show A,B,C,D.

      How can we get that?