Search Results Not Showing When Using Menus
I used DataAssist to create a Results, Search and Details page to return a list of our workshops.
When I was going through the Wizard, I selected the menu feature to narrow down the search on my search page. I dynamically linked the menus to their appropriate SQL tables (this may be where I messed up). Ideally, I would like give the user the option to make a selection as to narrow down their search. I did create the necessary SQL tables in my database so the menus could pull the correct data.
When I tested the pages, I used the menus on my search page and nothing came up ("no results were found"). I tested my connection to the database and the recordset was returning the correct data. I also removed any sorting taking place in each recordset (in case that was messing up the search page).
Is there suppose to be a URL variable or string query to trigger the search? Does DataAssist make available the necessary triggers when using menus to return the desired results?
Note - I added a static option to my menus (using your video tutorials) so the search page was not taking into consideration the values in each menu.
I am at a loss. I was hoping you could take a look at my files (see attached) to see if I am missing something or if changes need to be made.