I'm not sure what to title this...sorry.
I am doing a survey and am creating a data-base in ACCESS to store the results. I have a table for the results, a table for the possible answers, and a table with all the questions. There are 30 questions and 10 sets of possible answers (true/false, Yes/no, etc). I have done this in the past and then just created a form where I did text fields and re-typed in the questions, and then chose one of the answer types (yes/no, for example). However, I'm sure there is a way to be able to just have the questions from my questions table, as well as the possible answer types, show up on the form. My guess is I need to link the two tables somehow...but that is where I get confused! I don't really understand linking.
Any help you can give would be appreciated!
Thanks,
Jeanie
I am doing a survey and am creating a data-base in ACCESS to store the results. I have a table for the results, a table for the possible answers, and a table with all the questions. There are 30 questions and 10 sets of possible answers (true/false, Yes/no, etc). I have done this in the past and then just created a form where I did text fields and re-typed in the questions, and then chose one of the answer types (yes/no, for example). However, I'm sure there is a way to be able to just have the questions from my questions table, as well as the possible answer types, show up on the form. My guess is I need to link the two tables somehow...but that is where I get confused! I don't really understand linking.
Any help you can give would be appreciated!
Thanks,
Jeanie
