search records with filter from different tables

I have to tables with a relationship one to many, such as Orders and Order Details.

In the Orders table I have fields like: Customer, Shipping Date, Order Date, Total ($), etc

In the Order Details I have fields like: Item, Description, Category, Quantity, Sales Price, etc
ASP Runner generates obviously two different *_list.asp pages for Orders and Order Details, and we can drill-down from Orders to Order Details via a link (automatically generated as well).

However, we would like to search at the Orders level all the orders where customers bought books for example. So I would like to perform a search against the Orders list selecting the Category as criteria, although it belongs to Order Details.

This can't be done creating a unique view on the database side, because otherwise the Orders list would have duplicates/repetitions in order to accomodate the one to many relationship.
How could this be done and if now it is not possible, will it be implemented in the future?
Thanks!