Hi I have created a database that is meant to collect data about a study I am doing. It contains 2 main tables - 1 table regarding the staff that is working on the study and 2. Details about the participants and all their data (derived from a number of different forms/questionnaire).
Initially I had each questionnaire on a separate table but someone said it was not good database design and since there is a 1:1 relationship between the details about the participant and each of the questionaires, i.e. each participant cannot only fill out each questionnaire once) that I should have it all in one table.
However TheAceMan1 from the Forms forum said I should come here to discuss the table design etc since I am having issues with the design of one of my forms.
I am not certain about why he thinks there is an issue or why if there is an issue why its causing my problems but you can view the discussion here:
Here is a copy of the database also. The data is dummy/fake.
If anyone could help me as soon as possible I would really appreciate it. I am supposed to start using the database soon.
Initially I had each questionnaire on a separate table but someone said it was not good database design and since there is a 1:1 relationship between the details about the participant and each of the questionaires, i.e. each participant cannot only fill out each questionnaire once) that I should have it all in one table.
However TheAceMan1 from the Forms forum said I should come here to discuss the table design etc since I am having issues with the design of one of my forms.
I am not certain about why he thinks there is an issue or why if there is an issue why its causing my problems but you can view the discussion here:
Here is a copy of the database also. The data is dummy/fake.
If anyone could help me as soon as possible I would really appreciate it. I am supposed to start using the database soon.