Data Entry questions and Answers Form

[Luvlimum]

I am testing a number of Software Apps.
There are thousands of individual things to test based on various criteria.

This is what I have

tbl_Tasks
TaskID............(anum)PK
TaskmasterID...(num)
Task................(short text)

tbl_Tests
testID............(anum)PK
taskID............(num)FK
QuestionID......(num)
TestDate.........(dd/mm/yy)
Testversion.....(Short text)

tbl_Questions
QuestionID.......(anum)PK
Question..........(short text)

tbl_Responses
ResponseID......(anum)PK
QuestionID.......(num)FK
Response.........(short text)

tbl_AllTestData
ATID...............(anum)PK
testID.............(num)PK
TestDate..........(dd/mm/yy)
TestVersion......(short text)
QuestionID.......(num)FK
ResponseID......(num)FK
StatusYes/No....(y/n)
Method............(short text)
Comment.........(short text)

I have a form which loads the task, then a subform linked to the task which loads the test details.

A subform is linked to Test Details which is a dropdown box to choose the question (feature of the app that will be tested).

A subform that is linked to the Questions which provides a list of the test criteria which are from the table Responses

The tricky part is.....

I need the last subform to show/populate with all the responses that are linked to each question. There can be 8 responses to one question that all need to be actioned and tested.

I would like to add all the information automatically into the All test Data table which will generate my reports etc.

But I am stuck and don't quite know how to make this happen from here. I am sure I have done it before but it would have been years ago and when you have been away from Access for some time, your mind can go rusty.

Thanks for your help.
Please let me know if I have not made it clear enough. I would post an image of my table relationship schema but don't have a website to host it.
Cheers
Luvli

 

[Uncle Gizmo]

Re:- I need the last subform to show/populate with all the responses that are linked to each question.

I'm not 100% sure that I get the gist of your question. Taking a step back and making an observation about how MS Access works, if you have a subform it links to the main form through a subform/subreport control which has two properties in it presented like Fields. These are named master link and child link. You enter the name of the field in the master form that relates to the records shown in the child form. (the form contained within the subform subreport control)