Classic ASP - How to count total number of records from one query related to another query.
Posted on 2006-07-06
Hello. I am using Classic ASP with MS Access. I'm not overly clear on how to explain my question, but I'll give it a shot.
I have a page that lists all the products we support in a tree-menu fashion, as below:
There is a Master query for the CATEGORY, and a Detail query for the PRODUCTS.
We have labs associated with various product numbers. I have a separate table for labs with a foreign key related to the PRODUCTS primary key (the Product number).
I would like to be able to place a number is parentheses to the right of each product number, indicating the total number of labs for that product. [i.e. Product 1 (2 labs)].
I am not sure how to go about this. I'll post the code, if anyone needs it.
Your help is appreciated,