I have a student tracking app and am trying to create a list of the students based on whether they are in one of the classes so that I can mark them as either present or absent or tardy. The class is PE 1.
I have many tables all connected through student id. The table that I'm using for the attendance is PE1 Attendance. I also have a table PE assignment that assigns students to PE 1, PE 2, or PE 3. I only want to track PE 1.