Selecting from two listboxes

[claire_bicknell]

I am not too sure as to how I go about implementing this but ideally I would like two Listboxes.

The user will select a place from Listbox 1 and then listbox 2 will show a list of restaurants. You select your favoured restaurant and then information will be generated in the form of labels/textboxes like opening/closing times and address for that particular restaurant.

I am using a SQL Server database to do this.

Any help would be fab

 

[niroopa]

Private Sub ListBox1_SelectedIndexChanged(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles ListBox1.SelectedIndexChanged
' in this function load items into listbox 2 based on itemselected in listbox 1
End Sub

Private Sub ListBox2_SelectedIndexChanged(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles ListBox2.SelectedIndexChanged
' now in this function et the details about the restaurent based on the selection made in listbox 1 and 2 and display them in other controls
End Sub