I am doing a database that is in a questionaire or survey format. This is my first time doing this.
I have a table for questions and a table for responses.
This is what I have Im trying to have a dropdown that is based on the questionID
This is giving me a error but is not explaining why.
When you make the form how do you make the answer part show the drop down answers for the questions if the response answers are in another table?
When you have over 200 questions is it wise to put the questions in two colomun fields