I organise classes and I am building the base to manage them. I created several tables:
all those tables are joint in another one called “groups” that is where I create the class that is going to be held on a certain date, by certain instructors and with x students. Sometimes the students are going to be enrolled by me, and everything seems to be ok: if a student is not in the students table already, I can add it.
But I want to be able to send to the instructor a form so that, at the end of the course, he can add:
name, ID card number, if the student passed or not the exam, and the roster scanned.
I don’t want him to see all the fields that I have populated already.
Sometimes the instructor is going to have several classes forms on hold. He has to know which is he fulfilling.
But, if I create a form, it is as if I pretended the instructor to create a whole new group. I don’t know how to send a form of a group that I have created already, so he can add the pending data, and I don’t know how is he going to add the students checking if they are in the Base from a previous class.
I don’t know if I managed to explain well my needs and troubles.
Thank you in advance!