Setup: We have a Microsoft Access DB that houses Testing. Each test has 10 questions with 4 multiple choice answers. We have a test table, a question table and an answer table with a FK linking them. The Questions are displayed in a subform on the Test form and the Answers in a subform (continuous form) within the Questions form
Question: I would like to browse through a previous test and copy a question to a new test with it's corresponding answers. When the question gets copied, the only new piece of information will be the FK will link to the new TestID (combobox selection) and the FK in Answers will link to the new QuestionID (auto)
Question: I would like to browse through a previous test and copy a question to a new test with it's corresponding answers. When the question gets copied, the only new piece of information will be the FK will link to the new TestID (combobox selection) and the FK in Answers will link to the new QuestionID (auto)
