Wednesday 30 April 2008

Cascading Select List in a Tabular Form

This is something the most of the ApEx Developers have a problem with. How do I create a cascading select list in a tabular form? There are several examples (also in my Demo Application) on how to do that in a simple form. However, there is only one example arround showing how this can be done - in Vikas application, but I don't like that approach. I have also been asked several times to create such an example. Here we go! In my Demo Application you will find a working example showing also how to create an update and delete process + some javascript for checking and highlighting of all rows in your tabular form:

http://htmldb.oracle.com/pls/otn/f?p=31517:176



This approach is using apex_item + the same javascript (ajax) code as for the "simple" cascading select list.

Apply for an account if you would like to see all of the code behind this example.


4 comments:

Carl Backstrom said...

Hello,

Hey you might want to extend it to support multiple select lists , something like this http://apex.oracle.com/pls/otn/f?p=11933:161

Also since your returning the null value display maybe slip in the number or records returned
- Select Employee (4) - ?

Carl Backstrom said...

very nice example as well ;)

Denes Kubicek said...

Carl,

Thanks for your suggestions. I implemented the number of returned records in the select list. In one of the next examples I may include the multiple selects as well.

Denes Kubicek

Ernesto said...

Hi Denes,

The apex example link is not working, could you help us to log in, thanks!