UPDATE
I hadn't read the How to make a form popup thread before posting this message so some of my quesries mya be answered there
ENDUPDATE
Hi everyone
I'm looking for advice and suggestions
I have a question table
the fields are
QuestionID: kenrq2-65m50b9ttt
Question: What is my name
CorrectAnswerNo: 3
Answer1: John
Answer2: Brian
Answer3: Terry
Answer4: Oswald
Answer5:
I select a number of questions (say 10) randomly from the table
I now have a Memory table
SessionID: jdasd9rwrwrwrwr
UserID: 5353535fsff
QuestionSequence 1
QuestionID: kenrq2-65m50b9ttt
SessionID: jdasd9rwrwrwrwr
UserID: 5353535fsff
QuestionSequence 2
QuestionID: t665lm6-itetettte
etc.
What I now want to do is to loop through the 10 questions, bring up a memory form showing the question with each of the answers and next to each answer a checkbox where the user can check against the answer he thinks is correct. I will have to check that only one answer is checked and if another is checked then the previous check is removed.
At the end of the question set I would bring up a browse displaying all the questions with next to them the selected answers wording
eg
What is my Name Oswald
What is your name John
with an inline change button allowing the user to change an answer if they are not happy.
Once they have completed the test (click the renamed close button) I would then calculate the success percentage and announce the result( via a alert popup) and write the result into a table
Is the above the best way to go about this?
Any suggestions for a better way?