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.


on

4 comments:

  1. Carl Backstrom30 April 2008 at 21:21

    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) - ?

    ReplyDelete
  2. Carl Backstrom30 April 2008 at 21:23

    very nice example as well ;)

    ReplyDelete
  3. Denes Kubicek30 April 2008 at 23:44

    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

    ReplyDelete
  4. Ernesto5 August 2022 at 01:37

    Hi Denes,

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

    ReplyDelete