1 Reply Latest reply: Jan 18, 2017 12:43 PM by Gysbert Wassenaar RSS

    Association between fields of a table and selecting them

    Naveed Ahmed Janvekar

      Hi,

       

      I have a table as shown below:

       

       

      Field1Field2
      AB
      BC
      DC
      EF
      GF
      GH
      IH

       

      A in field1 is an equivalent to B in Field2 and B in Field1 is an equivalent to C in Field 2 and similarly D in field1 is an equivalent to C in field2.

       

      If I create 2 list boxes for field1 and field2, and if I select value A in listbox field1, I want the values A (in listbox field1), B(in listbox field2 and listbox field1), C in (in listbox field2 and listbox field1) and D (in listbox field1) to be selected automatically since A,B,C,D are equivalent to each other. I have tried using triggers and select possible function but it is not able to perform as stated above.

       

      Any help will be appreciated!

       

      Thanks!