Hi,



I have a MS Access database of which extracts of two of the tables are listed below:



CATEGORY

CategoryID

-CategoryName



PRODUCTS

ItemID

-CategoryName



In the Products table, CategoryName is looked up via the Category table.



When calling it in ASP.NET, the SQL I used to list the categories is:

SELECT DISTINCT Products.Category, Category.CategoryName FROM Products LEFT JOIN Category ON Products.Category = Category.CategoryID



Now, what I want to do, is be able to click one of those category links and it lists all the records which match that category, but I am struggling to get it right.



Can anyone help please?



Thanks