I'm creating a course guide database in Knack Builder Pro for several high schools in a school district. So far, so great.
At this point, anyone can view a course page, and then click on its connecting registration page with a form. When a registrar opens a registration details page (sign in required), I need to show them all other registrations associated with that same student ID (a field in the course registration form). They need to see how many course registrations each student ID is affiliated with... so they can approve, deny or put any of them on hold.
It would also be great to stop a single student ID from registering for more than X amount of courses... perhaps prompt them to remove another registration, before they can add another one. I want to avoid requiring any student or parent to create an account in order to use this guide... I just want to limit how many course registration records can use a single student ID.
What's a good way to do this stuff? I'm pretty failure with the system at this point, so even theoretical explanations might help me out :-)