Script that creates multiple dataentrys in a jointable?
I have theese two tables, one is called assignments, and the other tasks. Every assignment consists of a bunch of tasks. The tasks are always the same.
There is also a join-table, it consists of three columns, TaskID AssignmentID and completed. The completed column is set to 0 or 1 and states wether the task is completed for the specific assignment.
Here is my problem:
Everytime I create a new assignment, I want to create a new data-entry in the jointable for each task in the task-table.
Any help? I'd appriciate it a lot!