Hello, I want to make a database for a form that will have several questions of the type: 1a. Are you a smoker? If yes please answer question 1b, else go to question 2."
Does anyone encounter such form questions and have a solution to how to go about doing this? I could, and probably will unless I get some advice here, just make a table with fields associated with the questionnaire and let them leave them blank, but is there a programmatic way to guide the user to the correct question if they make the response?
I thought about using the visible fields properties to hide the question, and then use an on event macro to reveal it if the answer is yes for example. But I'm not sure this would be a very good way to do this.
Does anyone have some thoughts?
Thanks so much,