0 Replies Latest reply on Apr 28, 2010 1:11 PM by Kristoffernolgren

    Script that creates multiple dataentrys in a jointable?

    Kristoffernolgren

      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!