How can I auto-assign data to a student?

[Guest]

I have a training database in which the students are in either 5-level or
7-level upgrade training. I have a master task table(Classes) and a
sub-tasks table(Assignments). The sub-tasks are broken down into 5-level or
7-level tasks. In my Students form I select whether the student is upgrading
to a 5 or 7-level through a toggle switch.
Instead of going through and having to assign the student to each sub-task
individually (it came from a template), how can I get access to auto-assign
all the tasks automatically when I select the 5 or 7-level toggle?

 

[Guest]

I would need to know more about your database structure.
Do you use a junction table between student and classes? Run an append
query for the student and all 7-level courses.

 

[Guest]

I have three tables that I mainly work with:

Classes - Primary Key is Class ID
-- has a subdata sheet to assignments
---Relationships: ClassID (Classes) to ClassID(Assignments) and
ClassID(Classes) to ClassID(Students and Classes)

Assignments - Primary key is AssignmentID
--- Relationships: AssignmentID(Assignments) to AssignmentID(Students and
Classes) and Upgrade Training(Assignments) to Upgrading ToStudents)

Students - Primary key is StudentID
--- Relationships: StudentID(Students) to StudentID(Students and Classes)

Can I assume correctly that the Students and Classes table will be my
junction table?