APEX

I am attempting to take a PL/SQL package and put it in APEX 3.0. To do this, I am investigating the best way to take questions (with field types of select list, text, multi-select, radio buttons, checkboxes, and other types), associate them with the appropriate answers, and present them nicely to my end users.

So far, I have had limited success with creating an HTML region with a PL/SQL source (anonymous block). However, I am running into trouble with the more complex functions like creating a multi-select list, and I haven't even started to tackle the database update part.

I was wondering if any of you more experienced APEX people might offer some suggestions on the best way to handle this type of application? The HTMLDB_ITEM package seems to have limitations, and I haven't been able to get the SELECT LIST_FROM_QUERY to work at all (I keep getting data type error?). I got around that by creating my values list as a static list in a called function.

One of the update parts I want to consider is an automatic refresh at the end of each action -- sort of a 'select with submit' function, so I can eliminate any inappropriate questions based on the users' response to previous questions. (I currently have a skip to feature in my PL/SQL, but now they are requesting ALL the questions be presented at one time for user simplicity...understandable, but difficult to achieve, it seems to me right now!

Anyway, any suggestions would be greatly appreciated.

TIA,

Deb