auto-populate dropdown is the answer

May 6, 2005 by Chris Charlton

But you do want to auto-populate the dropdown, auto-populate with the labels/values of your Categories. As for using the same page with different data, the SQL Query will use the Category as the WHERE clause, and you can assign the value of the WHERE Category to come from the dropdown, all in the 'Advanced' SQL dialog.

Hi I think this is what you want

August 23, 2005 by Fahd Murtaza

I am a bit sure that what you want is something like

http://cc.1asphost.com/fahdi/business/

Ok, if this is something you need, I can be of help.I can give this code to you.

Regards,

Fahd Murtaza