Now and then I have the need of creating some kind of dynamic form, i.e. having the user define one or more questions and decide the input type, ie. text, date or select. I useually create a maximum of questions with the 3 field types and hide the types per question not needed. It's not ideal, but it works. The issue is that I want the select field react to input the user has given while defining the question. The approach I like is to create a select field on a temporary table which is filled with the available options in the onload event. The generation of the php does give an sql errormessage (as the temporary table does not exists at design time) but if you run the application it works well. Bottom line of this remark is to do a feature request to be able to use temporary tables and avoid errormessages.
No announcement yet.