APEX

Hi,

I am trying to build something similar to the Survey example available from HTMLDB Studio, but more advanced in that it should allow the administrator to create several surveys, each having its set of questions, to define what type of UI control to use to capture the answers (dropdown, textbox, radio button, etc.), and to define a list of possible values for controls like dropdowns. Then, questions should be displayed with the proper UI control on the same page (a parameter of which is the survey_id).

I have been trying to use an updatable report, but I can't condition the tabular form element to a value of the SQL query the report is based on.

The fallback plan is to create one table per survey, but that is obviously a much less maintainable system...

Has anyone attempted something similar? Any suggestions?

Thanks,
Guillaume