Not sure how i can achieve this or if PL/SQL would be even be the appropriate method for doing this.
This is the scenario.
I have a table with 2 columns. Category, Product, .
In apex i have an application with 2 drop down list,
1 is for Category and the other is for product,
I would like to select a Category, and for the product drop down list to be populated with the products within that category, without refreshing the page.
I can achieve it now with a sql query on the drop downlist, if I submit the page on selection. But this is not efficient.
the table may have data like this
Soda Diet Coke
Cereal Frosted Flakes
Cereal Apple Jacks
Cereal lucky charms
I would like to select Soda on my first drop down list, and for the 2nd drop down list to only have pepsi, 7up, diet coke.
Can someone please set me on the right path.
Again, the key is to achieve this without refreshing the page.