The following diagram (hopefully) displays what I would like. Say I have a database of pupil-teacher information from a school, two tables: one with pupil-class; the other class-teacher.
The first question in the survey asks what class they are in and the pupil selects appropriately. Their answer is then fed into a prepared SQL statement that pulls out those teachers associated with the selected class. These are then fed into the survey software so that the list of appropriate responses for the second question can then be generated.
Question: Which survey software enables this kind of possibilities?
Note: Every time I search for 'survey software database' I only seem to get hits that assume the database is needed as a place to deposit the responses. Perhaps someone can suggest better search terms.