Relationships?Form for Research Database Problem

[Ali baba 3]

Hi all

I've been asked to set up a research database and I'm having some trouble with it.

The idea is to have 3 tables: one for participant information, one for test results, and one for questionnaire results. Then I want to create a single form in which new participants details can be entered along with test results and questionnaire results. However participants will be followed up and as such one participant will having multiple test results and questionnaires completed on different dates. As such I've created

tblarticipant information
Participant ID: PK
Fist Name
Family Name...etc

tbl: Screening Test
Participant ID
Date of test: PK
Location...etc

tbl: Questionnaire
Participant ID
Date of questionnaireK
...etc

When I created a one to many relationship with referential data integrity between participant and the screening test table and created a form with just the two tables information in it, it all works fine. However when I try to add the questionnaire table fields onto the form then form goes blank. I was able to get the form to show up but then I couldn't add any new records.

I would not prefer unique identifier such as a questionnaire ID or test ID as this would be confusing as the participant ID and date is the important features. I considered merging the screening test and questionnaire table together but I think it would be better for this not to be done as only the test or the questionnaire might be performed on a subsequent date.

I'm just wondering if anyone has any suggestions about what relationships, and PK I should use to get this going ?

Thanks for any suggestions

 

[Cronk]

I'd have a main form based on tblParticipants and two sub forms one based on tblScreening Test and the other on tblQuestionnaire.