I am new to Oracle APEX and have built what I think is a simple application. I built an interactive report. I have 4 parameters for the report, and I display the report in a region on the same page based on the query parameters. The report only displays two columns, an ID number (not unique), and a unique type.
What I want to do is to set an item value to that of what is in Column1(IDCODE). The reason I need to do that is so that I can then pass that item back to my database in a second query.
I hope this makes sense, I can elaborate further if necessary.
Thanks for any help you can give.