Apex 4.1 - Oracle 11
I have a simple tabular form with 2 drop down columns with sample values
column 1 Column 2
Department Department Service
Biology Service 2
Math Service 4
Social Studies Service 4
So I want to be able to use the values selected and do something with them (ie. use them in the query on the page).
I can't use a page item select list as I don't know how many departments will be selected, it is up to the user. and for other reasons as well I need to use a tabular form here.
![]()
So if they select Library Services then somewhere else on the page I want to do a query (probably a dynamic action on change?) based on that selection and use the value on the page. I don't know how to access the first column value, I'd like to take that value and stuff it in a page item and use as needed then on change I can refresh that page item with the newly selected value
Here is the html for the first department selected
![]()
I would like to do the following set apex_page_item1 := tabular form column 1 row 1 (f04 and id f04_0001)
and now be able to do a query Select * from aDifferentTable where NewDepartment = apex_page_item1
Which in the above case would be equivalent to -- Select * from a DifferentTable where newDepartment = 'Library Services' (the value that is selected from that row)
If you can just tell me how to access the value from the first tabular form column I could probably firgure the rest out, thanks