Oracle APEX: Add list boxes on demand

175 views Asked by At

I am new to APEX and was wondering if you could point me in the right direction. I have an app that has 24 pairs of list boxes, (24 is the limit per requirements). What I did was create and show all 24 and it looks weird. (See image here). enter image description here

My question is this: Is there a way to have maybe just one pair show and as they make their selection, a new pair of list boxes appears? Or maybe have a button that says something like "add a new category / type" and once clicked, a pair of list boxes is created? This would go on until they've populated the 23 sets of list boxes since 24 would be the limit.

By the way, the selected category value drives the type value. On the linked image, the size of the list boxes varies because of this. Can those list boxes be made with a fixed width?

Oh, I'm using 4.2.

1

There are 1 answers

0
Jashelb1990 On

Having read through the posts on this, if you did want to attempt creating a report which has cascading select lists you could try the approach found at this link:

https://apex.oracle.com/pls/apex/f?p=39514:1:

It's a slightly long winded process so it may not be the easiest solution, however having read through the instructions the guy provides it seems do-able:

https://apextipps.wordpress.com/2010/11/02/cascading-lov-in-tabular-form/

Hope that is of some help.