Slug query through a page

Hi there,

I’ve created a new page and named it “products”. This page is linked to a custom template which queries few products from a MySQL with the WordPress DB API (wpdb). Now I have some products and I want to get to the detail page of each product. The URL should be like that: myblog.com/products/theproduct. But when I click on a product, I get a 404. How can I tell WordPress, that the word after “products” is a query with own detail page?

Thanks!