Hi Andypitts Thanks for responding. Last year we set up for example a behaviour aspect called KS3 Behaviour which was used for Years 7 to 9 and a simular aspect for 10 and 11. Each aspect was then used within the marksheet within results sets Autumn, Spring, Summer.
I think what you are telling me is because the aspect is called KS3 behaviour that when the kids moved from year 7 to 8 the data entered in year 7 moves across to year 8. What I shoudl have set up was an aspect called Yr7 Behaviour, Yr 8 Behaviour etc. This would then produce a clean marksheet each year.