run through the Data Assist wizard to create the products search, results and details. on the manage pages tab, edit the configure field settings section, and set the ProductCategoryID column to be a menu, set it to use the categories table, use the category name as the label, and the category ID as the value.
after the products pages are created, open the product search page, select a category and submit the search, make note of the URL variables, you can use that search string as a base for the links from the category details pages to the products results pages, just substitute the category ID from the Category details recordset in the link.