I am running into an issue with creating a view which has multiple rows for either creating or editing.
The scenario is such:
I need to create a view to enter the results of students. The functional logic required is that the user would select a student from a list and depending on the student's grade, the relevant subjects need to populated as a grid along with an empty text field for entering the marks. The data would then need to be updated in the results table.
The screen could be something like this:
http://www.freeimagehosting.net/uploads/b43419c260.gif
The subjects need to be dynamically populated depending on the student selected.
I have three tables:
STUDENTS
StudentId Name Address Grade
SUBJECTS
SubjectId SubjectName Grade
RESULTS
StudentId SubjectId Marks
I essentially need to create a view to capture the results. Somehow I have not been very successful so far. Sample code would be a major help.