I have two list item on same page and both are getting list from two different tables in database. One list item is showing the brand like HP, Compaq, Acer .... and other list is showing the categories like Server, Workstation, Monitor, Thumb Digitizer ....
Now i want that when user select a brand from one item list, at his/her selection other item list only show those categories which are related with that brand. both tables are joined at brand_id. I'm working in VBScript currently. is there any solution?

Thanx

Only populate the Brands list first. Then get the selected item(s), and pass as a parameter.

Ex. Select <columns> From <table> Where brand_id = <selected id(s) in list>

Then use that result set to populat your categories list.

1- dear i'm confuse that how i implement it. look i have to record sets which are populating to list items on a same page. one recordset is "select brands from product" populating list item "brand" while other recordset is "select categories from product" populating list item "categories". but i want that when user select brand from brand list item page refresh and show only the categories which r related with that brand so i'll replace second query with "select categories from product where brand = '" & BrandVariable &"'"
but for this i have to press submit button. i don't want to use submit button. i need when user select brand page should refreshe on select.

2- the second think, i have created a link on for example "Item". when user click on "item" it executes a query and shows the specification of that item on next page. is it possible that when user click on "item" a popup windows should appear and show the result of that query in that popup window.

i hope u can understand my problems

thanx

Hy,

For 1 : wot u can do is to execute query for populating
the second list on the First list's 'selected index changed' event.

can any1 plz write a sample code that how can i populate second list on 'selected index changed' event. i shall be very thankful.
Zee

Hy..

1) on page load event populate ur first list by using query
like this one--"qu = "select brand_name from Brands""
2) on selected index changed property of first list populate the
2nd list by using a query sumwot like this one--
"qu = "select category_name from categories where brand_id = select brand_id from brands where brand_name='" & ddl1.SelectedItem.Text & "')""

3) bind ur 2nd list.

hope this helps.. !:)

Ciao..
It bcums FATAL wen my brain puts my eyes on Call-Waiting ! >|B-)