I have a SharePoint list called 'Teachers'.
In that list there's a column called 'Subjects'.
Subject column is of type drop down and has eights subjects in it and has multi select option enabled.
Every teacher entry has two subjects(min and max) added in the subjects column.
The Subjects column in table 'Teachers' is on Sharepoint and is of the type 'choice' and 'multi select' is enabled. All these properties are set in Sharepoint.
So against each teacher row, Subjects column holds two subject names.
I need to display the eight distinct subject from the 'Subjects' column in a drop down to the user.
How do I do it?