Hi, You need to implment the parent-child relationship between the two tables to get the desired results. You may try the following code snippet: --------------------------------------------------------------------------------------------------- BEGIN CODE Dim dc As OleDbConnection Dim connstr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:\Nwind.mdb;" Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim da As OleDbDataAdapter Dim dt As DataTable Dim dv As DataView dc = New OleDbConnection(connstr) da = New OleDbDataAdapter("Select * from Products", dc) dt = New DataTable da.Fill(dt) dv = New DataView(dt) Me.ListBox1.DataSource = dv End Sub Private Sub ListBox1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ListBox1.SelectedIndexChanged Dim SupplierIDString = Me.C1Combo1.Columns("SupplierID").Text.ToString() Dim da As OleDbDataAdapter Dim dt As DataTable Dim dv As DataView dc = New OleDbConnection(connstr) da = New OleDbDataAdapter("Select * from Supplier where SupplierID = '" + SupplierID+ "'", dc) dt = New DataTable da.Fill(dt) dv = New DataView(dt) Me.ListBox2.DataSource = dv End Sub END CODE --------------------------------------------------------------------------------------------------- Hope this helps :).
Regards, John Adams ComponentOne LLC