Database Relationship Help

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • javatech007
    New Member
    • Nov 2007
    • 51

    #1

    Database Relationship Help

    I have this relationship set up but my list box wont display the child data even though the code compiles grand.

    Here is the code

    [CODE=.NET]
    Public Sub FillCustomerAcc ounts()
    Dim objDetails As DataRow, objAccount As DataRow
    Dim strAccountEntry As String

    lstAccounts.Ite ms.Clear()

    objDetails = objDS.Tables("C ustomerDetails" ).Rows.Find(cbo Accounts.Select edItem.ToString )

    For Each objAccount In objDetails.GetC hildRows("Custo merDetails2Cust omerAccounys")
    strAccountEntry = objAccount.Item ("PIN")
    lstAccounts.Ite ms.Add(strAccou ntEntry)
    Next

    End Sub
    [/CODE]
Working...