Hi
I have the following tables with the below sample data
STUDENT_MASTER
STUDENT_NO NAME STD
1 ABC 10
2 XYZ 8
EXAM_MASTER
SUBJECT NO SUBJECT NAME MAX MARKS STD
1 MATHS 100 10
2 PHYSICS THEORY 100 10
3 PHYSICS PRACTICAL 200 10
4 CHEMISTRY THEORY 100 10
5 CHEMISTRY PRACTICAL 200 10
Now here is what I would like to do
Select Student <Dropdown with Student Name> Exam Date : <Input date control> Std : <Label Display based on student selection>
Enter the Marks
Grid
Subject Name Max Marks Marks Scored %
MATHS 100 <input box> <Calculation label>
PHYSICS THEORY 100 <input box> <Calculation label>
PHYSICS PRACTICAL 200 <input box> <Calculation label>
CHEMISTRY THEORY 100 <input box> <Calculation label>
CHEMISTRY PRACTICAL 200 <input box> <Calculation label>
<Save Marks button>
Once a Student Name is selected from the Drop down; we need to identify the class that student belongs and then populate a grid based from EXAM_MASTER.
I should be able to enter the Marks scored for each subject and % has to be calculated
Then finally I would like to save the following to the below table when a Save button is clicked in the following table
STUDENT_MARKS_MASTER
MARKS_ID Primary Key
STUDENT_NO
EXAM_DATE
STUDENT_MARKS_DETAILS
MARKS_DETAILS_ID - Primary Key
MARKS_ID - FK to STUDENT_MARKS_MASTER table
STUDENT_NO - FK TO STUDENT_MASTER table
SUBJECT_NO - FK to EXAM_MASTER
MARKS_SCORED
Hope I am clear on what I want to achieve. Big issues is I am not able to think how to generate the dynamic grid to list down the Subjects along with Inputs
Thank you for your help
Regards
Murali
I expect SC Support Team to guide me here.