The standard approach to this is: create …
• a table Examination
• a table Test
• a table ExaminationTest
That's the template from which you set up the actual tests.
For that, you need
• a table PatientTest
• a table PatientExamination
All this is combined as
Patient --< PatientExamination --< PatientTest >-- Test --< ExaminationTest >--Examination
Now you need scripts that:
• let you select an Examination (or several) from all Examinations
• then create a PatientExamination record (or several) for the current patient and the selected examination(s)
• find the Tests that belong to the Examination(s) as per ExaminationTest
• copy them into PatientTest and relate them to the new PatientExamination record(s)
These scripts can be a bit complex, but not really complicated.
If you imagine the above template structure as a folder of paper-based questionnaires, then you just performed the equivalent of taking one (or more) out, putting it/them into a photocopier, creating a copy / copies and personalizing it / them with a patients name. There is your checklist.
Now you can simply compare the number (count) of all related records (for the patient in toto, or per examination) in each table with the number of completed related records.
Thank you Erolst for your answer,
Somethings are a little confusing for me! You say I should create both "test" and "examination" tables? what do you mean of that? Actually they have the same meaning for me!
Maybe you mean "List" ? right?
And after that, what does do exactlly this script? I did not get it