create the results page to show the all records.
the start the data Assist wizard to create the search page.
in the data assist search wizard, set it to search the ProductCategory column using a select list.
after the page is created, populate the select list with the categories.
see this thread for details on resetting the search results: