creating a form with results from 2 seperate queries

[m1kegbrown]

I am trying to create aa questionaire where I do not have to enter in the questions and answers statically. I have made table of questions and a table of answers and a joining table that has the id from each of the preceeding tables. The problem is every time I make the table I never get the right result.
When I use a query to produce a result of all the questions that link to the questions I get multiple instances of each question (which is to be expected).
What I want to figure out is how in a form to get each question to display once with a pull down(combo)box next to it. In the pull down I would like it to be populated with all the answers associated with that question and only that question.
In addition I need to figure out how to take these results and post them to another table that has the users ID and the questionID and keywordID so that I can look up there reults later

 

[Dugantrain]

I don't quite see what you would need a linking table for. A linking table would be for a many-to-many relationship. It sounds like one one-to-many relationship would serve your needs (one question, many answers). In this way, you could have your parent form be directly from the Questions table, your subform from the Answers table, and then each time you selected a question out of your combo box, then your subform would populate with all Answers to that Question.

 

[m1kegbrown]

linking table

The problem is that one answer can be used by different questions.
ie.
how was the teachers method of teaching
very good good neutral not good bad
How did you do in this class
very good good neutral not good bad

But the interesting thing is there are multiple questionaires and
question too can be reused on multiple questionaires
does that make sense