I have two tables, Student and Mark. The mark table contains the student marks in 8 different subjects and for 3 seasons. Each student has 8 subjects marks. in other words, each record in the Student table has 8 related records in Mark table. I have tried to make a layout to show the students marks in each subject separately but I failed .
I would greatly appreciate it if anyone kindly give me some feedback.
thanks in advance.