creating a main menu with searc / look up criteria
I'm using Apex 3.0 for a client
I'm trying to create a main menu where the user can enter search criteria and when they click submit, it takes them to a different page to view the data
The main menu needs to just show the look up criteria, not display any data
I found documentation that shows me how to use list of values to do this where a drop down appears on the main menu, the user selects a category and then clicks on a button to take them to a separate page to display the formatted data.
I've got this working for several look ups
I also want to do a look up with a text field (last name) , where there is no list of values
I found documentation ( how to create a Parameterized Report) that shows me how to do this by creating a report on the page using a query with
WHERE
(lower(firstname) like '%' || lower(:P1_NAME) || '%' OR
lower(lastname) like '%' || lower(:P1_NAME) || '%')
where P1_NAME is a text item on the region and there is also a hidden item
The problem is that this displays the data on the same page that the report is on ( in this case the menu screen)
How can I incorporate something like this query but have the application branch to a different page to display the results? Any documentation that does something like this? Thanks