APEX

Hi all,

I have two multi-select lists called :P1_PARENT and :P1_CHILD. When a user selects a value from :P1_PARENT the values of :P1_CHILD are filtered accordingly. This works well and was very easy thanks to ApEx 4.0.

I would like to extend this so that a user can select multiple items from :P1_PARENT and filter :P1_CHILD's value accordingly. The problem I am having is that ApEx returns the :P1_PARENT values as a colon-delimited string and I am finding it difficult working out how to reference this in the SQL of :P1_CHILD, or how to go about creating :P1_CHILD from some PL/SQL function.

The SQL I wish to use for :P1_CHILD's LOV would be something like:

SELECT display, return
FROM table
WHERE parent_id in (:P1_PARENT);

This returns an error as :P1_PARENT is not a number.

Please help!
Thanks
Lucy