Hi I created 2 Dropdown Menus
(Parent & Child DropDown menu)

When ever I select child dropdown my results shows everything. How can I just show of what I have selected from the Child dropdown menu selections?

Can any give me how the SQL qurries to write for this? Below is my SQL what I have written for the results page.

--------------------------

SELECT grouptype, childvalue, childname, groupid
FROM child_table, parent_table
WHERE grouptype LIKE 'vargrouptype%' AND childvalue LIKE 'varchildvalue%' AND groupname LIKE 'varchildname%' AND groupid LIKE 'vargroupid%'

vargrouptype % Request.Form("grouptype"

varchildvalue % Request.Form("childvalue"

varchildname % Request.Form("childname"

vargroupid % Request.Form("groupid"
--------------------

Again I only want to get a results of what I have selected and not the whole results.

Thanks