Hello.
I am in the process of creating a database to keep track of my online quiz practice results and of the questions that I got wrong while practicing. There are 5 Quiz and each quiz has got 10 questions. The result that I would like to get, is being able when i open a table to see for all the attempts of a quiz all the questions I got wrong and that I need to review. I tried to create the database with a table for each quiz and for each attempt and set a quiz id as the primary key to link the table regarding the same quiz. When I am going to try to link the two tables regarding the same quiz with different attempts, is saying that is impossible to create the relationship because some there is no integrity in datas.
Could anyone to help.
Thanks so much!!!!