Hi. I created two dependent combo questions by steps in Demonstration 11 with version 2.60.70. But my first combo is initialized with data from SQL and the second combo is not initialized while it is hidden. My submit event executes INSERT SQL statement but default combos values are not assigned to appropriate $() question values.
Everything works after user select another value from the first combo and then value from second combo.
1. How to initialize both combos and appropriate question values on module load?
2. I need to display "1 item has been inserted" or "item already exists" message just after submit call. How to determine if INSERT statement succeeded? Can I call SELECT statement right after insert? Should I define another Form completion event of SELECT SQL type?
Thanks.