Auto select values in other fields of a table based on selection of an ID
I have a table as follows:
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.