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

[#1]

I have a table as follows:

Id	Course1	Course2	Course3	Course4	Course5
1	A	B	C
2	E	F	G	H	I
3	J
4	K	L	M
5	N	O
6	P
7	Q	R	S	T	U
8	V	W
9	X
10	Y	Z

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!

[vinieme12]

There is no need to select the corresponding  values separately as you are making selections on the rowkey

[vinieme12]

Read these

Logical Inference and Aggregations

Why is it called Set Analysis?

[vinieme12]

if you still want to enforce a selection then

create  listbox with Expression

=aggr(only({1}Id),Course1,Course2,Course3,Course4,Course5)

see attached app ! Make selections on ID field and try for yourself