3 Replies Latest reply: Jan 27, 2017 10:46 AM by Vineeth Pujari RSS

    Auto select values in other fields of a table based on selection of an ID

    Naveed Ahmed Janvekar

      I have a table as follows:

       

       

      IdCourse1Course2Course3Course4Course5
      1ABC
      2EFGHI
      3J
      4KLM
      5NO
      6P
      7QRSTU
      8VW
      9X
      10YZ

       

      I have created list boxes Id, Course1, Course2, Course3, Course4, Course5. Now, when I select Id as 1 in the listbox Id, I want A in listbox Cousre1, B in listbox Course2 and C in listbox Course3 to be selected (background of selection in green) automatically. Tried fieldindex function, but did not work. Similarly when I select Id as 2, I need E, F, G, H, I values to be selected (i.e.) the corresponding course values.

       

      Any help would be appreciated!

       

      Thanks!