For my university database, I have created a table (say X), which holds data as "Id, Name, Term1Marks, Term2Marks .... " some 15 fields. I want the faculty members to enter the marks through their portal (already developed). They wish to insert marks as follows:-
Dropdown --> Select Branch
Dropdown --> Select Subject
Dropdown --> Select Section
After, this the list of Section populates as follows :-
Roll Name Term1 Term 2 ...
123 XYZ 12 22
Inserting marks for Term 1 specifically. Is this possible ? If yes , How ??