I have a simple training database.
1 table for students
1 table for courses
1 table to join them (many to many)
I've just been asked to allow a tutor to create "Mandatory" training, which they would do using the courses form.
However the mandatory corse is for All current students.
What would be an efficient way of adding the new mandatory course to all current students?