1 Reply Latest reply on Sep 6, 2006 12:10 PM by Dan Bracuk

    Posting Multpile Records

      Problem: I want to create a test page with 10 Questions. The questions are pulled from the Questions Table. Testers will choose a value of 0-2 in a drop down. I want all 10 questions to post to the Test Table as seperate records with a TestID as a foreign key and TestQuestionID as the primary key. I can't seem to figure out how to create a trigger for each question so that it posts to a new record on one post.

      Any ideas, other then using Flash.

        • 1. Re: Posting Multpile Records
          Dan Bracuk Level 5
          My first idea is that your test-question table should have a two column primary key, testid and questionid. My next idea is to not bother with a trigger. Just do something like this:

          insert into TestQuestion (TestId, QuestionId, etc)
          select TestID, QuestionId, etc
          from wherever stuff comes from.