PopQuizT is not normalized structure.
PopQuizT should be a parent table then have a related table that stores selected questions for quiz.
Have a form for creating PopQuizT parent record then use code to write query records to QuizQuestionsT.
Something like:
Code:
If Me.Dirty Then
Me.Dirty = False
CurrentDb.Execute "INSERT INTO QuizQuestionsT(PopQuizID_FK, QuestionID_FK) SELECT " & Me.tbxQuizID & ", Rnd(...) FROM QuestionsT"
End If
The event to run code could be button Click.
What other data could go in PopQuizT - QuizDate, QuizProctor, QuizRespondent, etc. ?
Suggest you learn to use forum table builder on the Advanced editor. Can even copy/paste from Excel or Access.
Following is how I interpret your data info:
QuestionT |
PopQuizQ |
PopQuizT |
QuestionID |
PopQuizID |
Question1 |
Topic |
RND() QuestionID |
Question2 |
Question Answer |
|
Question3 |
Answer Points |
|
Question4 |
|
|
Question5 |
PopQuizQ Output
QuestionID |
Question |
Answer |
Points |
10 |
What color is the sky? |
Blue |
1 |
36 |
What color is grass? |
Green |
1 |
4 |
Is water wet? |
Yes |
1 |
102 |
Are dogs cool? |
Yes |
1 |
75 |
Is the sun hot? |
Yes |
1 |