I am setting up a transcript layout for students to show their accreditation record. I have a Student table and a Class Registration child table. I also have a Courses table with Classes child table and the Class Registration child table. I need to show the Courses that have a pass grade from the corresponding Class Registration. I also need to show only the highest mark for each Course if they have taken it more than once. I am having trouble because there is no Course primary key on the Course Registration, as the Course primary key is on the Classes table.
Could someone please give me their recommendations on how to go about this. Thanks.