Q&a

[*Pete*]

Hi,

I'm trying to create a database that holds data on people and some questions.

I have created two tables one for the people and one for the questions.

Is there a way that i can link the two tables so that when one of the people answers the questions the answers are linked to that person? I can only seem to do it if i add an id field and copy the questions over and over for each person. There must be a better way!

Each person must have an answer for each question.

I hope this makes sence to someone!

I have attached a copy of the db with 2 the two tables.

 

[grnzbra]

How often would people answer the questions? Would there be another set of questions at another time?

Assuming that there could be multiple "Tests" taken multiple times, you would need another field in the Questions table to indicate which test it was from You could use the two of them together as the primary key for that table. Then you would have another table with a person ID, TestID, Question ID, Which Attempt (or, possibly, the date) and the answer. The Answer table would be linked to the person table for data entry, while all three would be linked to each other for reports.

 

[*Pete*]

That is perfect thank you, that is exactly what i need to do.

Thanks for your help.

Pete