locked
Multiple Tables Query Result VB 2010 RRS feed

  • Question

  • Hello, I am working on a project that has three tables in a DB named companyTable, clientTable & productTable.

    CompanyTable has a companyID relationship to ClientTable companyID;

    ClientTable also has a clientID relationship to productTable clientID.

    Loading the

    three table relationship to a form is NO problem, I'm even deleting, updating and saving all three table.

    My problem is with the Query:

    When I build it, I can only do it from one of the tables and anything associated wtih that "ID" from the other tables is not displayed.

    The query builder generates the following line of code: 

    Me.CompanyTTableAdapter.FillByCompanyID(Me.CarSpoilSpaDataSet.CompanyT, NewSystem.Nullable(OfInteger)(CType(stringfind, Integer)))

    As you can see, only the CompanyTable info is displayed on the form and the other tables with the relational ID's are not displayed.

    Please help.

    Wednesday, December 12, 2012 9:50 PM

Answers

  • Danny,

    You might consider using LINQ-To-SQL to help you out.


    Please call me Frank :)

    • Marked as answer by Youen Zen Tuesday, December 18, 2012 9:04 AM
    Wednesday, December 12, 2012 9:59 PM

All replies

  • Danny,

    You might consider using LINQ-To-SQL to help you out.


    Please call me Frank :)

    • Marked as answer by Youen Zen Tuesday, December 18, 2012 9:04 AM
    Wednesday, December 12, 2012 9:59 PM
  • Thank you Frank, i will give it a try.

    Thursday, December 13, 2012 12:21 AM