I have a pretty standard database with pupils studying Maths at different levels. Each level has different assessments. I would like to know how to automatically add all the assessments for a level automatically to a pupil marks table when I add a pupil to a level table.
So if pupil1 is taking Higher Maths and its has 3 assessments prelim1, prelim2, prelim3. I would like to automatically add these.
I have attached my database as I am not even sure where to start, I am guessing it has something to do with appending data but have never mastered that.
Any help appreciated as I usually just add these manually.