AnsweredAssumed Answered

Script that creates multiple dataentrys in a jointable?

Question asked by Kristoffernolgren on Apr 28, 2010

Title

Script that creates multiple dataentrys in a jointable?

Post

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! 

Outcomes