Summary of My Project
Database to store names and attempts at completing different tests.
Person can attempt any test, several times.
Each time they take any test, needs to store: test name, date, and results.
There are 3 different tests. All tests are basic yes or no questions (so, "yes/no" or just checkboxes can be used) No multiple choice answers. Just yes or no.
My Tables
Table1 (PersonID, Name, Date, TestID) * main table
Table2 (TestID, TestName) * stores all main test names
Table3 (QuestionID, TestID, QuestionText) * stores all questions related to a specific test
Person enters name, enters a date, and selects a test. On update/change of test field, it loads the yes/no questions related to test.
I am not understanding the methodology behind next step.
- person can put yes/no values or check marks in box for results. Save test.
- they can attempt the test again at any time. So, if they took the test 5 times, saves the results of each test as a record.
I have tried creating Table4 (ResultID, PersonID, TestID, QuestionsID, and a field called Results (Yes/No). But, questions called to populate a page, with check boxes, does not work.
Do I select all questions related to a test from the table, and then update records in Table4?
I appreciate any direction.