Twin List box 1

[Deadline]

Hello,

Don't know whether this is going to be a repeat post... Apologise me if it is..

I have a question for you...

I want to populate two list boxes, the second one linked to the first one. I know to accomplish this when we link two tables. But I am not sure how do I do it with a single table..

For instance, consider the following rows :

---------------------------------------------
EMP_ID EMP_NAME EMP_DESIGNATION
100 George Bush President
200 Bill Clinton President
300 Al Gore Vice President
400 Dick Cheyney Vice President
---------------------------------------------

I would like to have the designation in the first list box and the corresponding Names+Value in the 2nd list box. Can you please tell me how to do this ? Thank you...
RR

 

[webspy]

ya sure
u can do this thing using one table.for that u use sql query to retrive the data from the table.
if u click the "president" on the first list box,on click even u write a query to retrive the content like

sql="select name,value from table where designation='" & president &"'"
it shows the list of name and value for the relevent designation.
regards
webspy

 

[Deadline]

Thank you Webspy.

My requirement was not to hit the server once again...Anyway, I found out a way from this URL how to do it .... Thanks yet again...

http://www.4guysfromrolla.com/webtech/101099-1.shtml

Thank you...
RR