I’m looking to create an inspection form which shows questions based on certain criteria.
The inspection starts with some general questions, then follows with questions based on another table (Questions_table) and finishes with some more general questions.
The questions to be shown are entries of the table Questions_table so the user can add questions if needed by adding a line in this table. The questions to be shown are based on a value within the first few general questions.
The answers to the questions should be recorded in another table (Answers_table) which simply records the inspectionID, Question and the answer given and possibly a picture and comment.
What would be the best way to implement this? I do not want a table with a few hundred columns with questions and answers which are shown by a certain condition. This way I won’t be able to add questions later.
Thanks in advance