First of all, thank you for your effort and answer.
It seems to me that we did not understand each other well because I did not explain the situation well (and I also incorrectly stated that it was 45 identical questions). I have to explain in a little more detail and more clearly:
- The questionnaire has 45 different questions (therefore, there are only 45 columns in the database for recording the answers to these questions!)
- it is necessary for the respondent to pass all the same 45 questions for 20 different assessment subjects
- the desired scenario would be: the respondent comes to the Questionnaire and on the first page (question) there is a list of say 20 subjects to be evaluated, each subject with the same 45 questions, but the results must be each separately. Let's say that the subject selection is made using a radio button type of question where only one answer is possible at a time. If he chooses, say, subject number 10, then the answers to the questions that evaluate subject number 10 go to one line of the database. Regardless of whether he completed all 45 questions for that subject, he wants to evaluate subject number 3. He returns to the first page and checks the radio button number three, and starts answering the same questions, but for subject number 3, those answers are also written down in a separate line in base, which is marked with the respondent's identification data and the information that it is case number three. If he now stops filling in subject number 3 and wants to return to filling in subject number 10, return to the first page and click on the radio button for subject number 10 and continue filling in the questions for subject number 10, the answers of which are written in the same previously started line in the database with the respondent and case number 10.
The problem with your proposed solution is that the system will write the answers in one line for the first time according to the principle: token of the person + value of the first question (which is the name of the subject) + answers to the 45 questions in the following columns. If we now go back to the first page and change the assessment subject, the system will go back to the same line, the token will remain the same, but it will override the assessment subject name and those previous 45 responses.
Otherwise, the matter can be solved by making 20 times a group of the same 45 questions and conditionally linking them to the initial list. However, such a solution turned out to be too big for me and the system worked very slowly!
I somehow think that my desired scenario cannot be done with the existing settings, but that maybe there is a workaround.
Well, I hope I have explained it well now and I hope there is a solution because it is quite important to me.