This is the second time I try something like this without success last time in a different context, in this evaluation context I think its easier to explain.
User should be able to resolve many exams (Multiple Choice Questions) a set amount of times. 3 Tries in this case. I created a database of EXAMS, a database with QUESTIONS (linked to EXAMS), and a Database with ANSWERS. I also created a database of TRIALS (so I can keep track in each try if the user passed or not and how many questions have been answered in such try). Another tricky part is that user should be able to come back to the evaluation and continue or change answered questions.
So, when user selects: Start Evaluation, a TRIAL is created, linked to the specific Exam and the User. I go into a “Trial View Page” where I display the QUESTIONS of such EVALUATION. I created a multiple to multiple relationship in TRIAL to the QUESTIONS(called Questions Answered). In a given Trial I want to be able to distinguish answered questions from non answered questions.
In my “Trial View Page”
I try to display a list of Current Trial>Evaluation>Questions and another list of Current Trial>QuestionsAnswered. But when they get answered I want them to be removed from the first list. Or something where the student can keep track of the questions that have been answered. I’m stuck there.
Can you guys think of a different approach? Would you create records for each question in each trial? I am a bit confused at this point.
The main point for me is how to create a list that displays items that are not in another list. In this case display a list of CurrentEvaluation>Questions that do no appear in CurrentTrial>Questions.