form to load a series of questions and answers

[m1kegbrown]

I have 3 tables a questions table (QID, question) Answer table (AID) and a join table (JID, QID, AID) I can't figure out how to make a form that lists each question and next to it a combo box to select the appropriate answers
I can make a query that produces all the questions (which are repeated for each answer related to it) but I need it to show each question only once then a combo to choose the answer to associate with it. I hope this makes sense if not let me know.
Need help asap.

 

[dcx693]

What exactly is the function of the join table?

Set up a form with a text box to hold a question and populate a combo box next to it with the possible responses. Then set the default view of the form to show continuous forms. You'll get each question and response within it's own "form".

One problem with this solution is that there's no simple way to display a "Done" button, so that when the test takers are done with the test, they can submit their responses. One way around that is to encapsulate the entire form mentioned above within another form that contains say, a "Load test" button, and a "Done" button.

 

[m1kegbrown]

the join tables are used because each test has an undefined number of questions that is pulls from a table based on its ID and each question has an undefined number of answers associated to it. that are assigned by an id. the problem is for each participant who takes the test they must be assigned the proper question with the proper answers assigned to them. I need a form to use so that when I question the people I can go through the list of questions and select their proper answer and then have this result added to a seperate table. I am confused because everytime I try this I get either all the questions (not the specific ones )with all the answers in a huge data table or nothing at all?