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?

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.

"apiedad" wrote:

> 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?

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?

"KARL DEWEY" wrote:

> 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.
>
> "apiedad" wrote:
>
> > 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?