I have three related tables:
2) Students (must be assigned a school)
3) Orders - the order is related to the student and the school, so I can see total orders by school, as wells as total order by student.
When I enter the order screen I have a portal that I want to filter all of the students and contact information by whatever school I choose. However, I only get the first student from that school in the portal, not any of the other students?
I know its a rookie error I am making but after 7 hours of trying to fix it I have had no luck.