Multiple Tables Query Result VB 2010

[EDN Admin]

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, Im 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: <span style="font-size:small
<span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small Me<span style="font-size:small <span style="font-size:small .CompanyTTableAdapter.FillByCompanyID(<span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small Me<span style="font-size:small <span style="font-size:small .CarSpoilSpaDataSet.CompanyT,
<span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small New<span style="font-size:small <span style="font-size:small System.<span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small Nullable<span style="font-size:small <span style="font-size:small (<span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small Of<span style="font-size:small <span style="font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small Integer<span style="font-size:small <span style="font-size:small )(<span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small CType<span style="font-size:small <span style="font-size:small (stringfind,
<span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small Integer<span style="font-size:small <span style="font-size:small )))
<span style="font-size:small <span style="font-size:small
As you can see, only the CompanyTable info is displayed on the form and the other tables with the relational IDs are not displayed.

Please help.


View the full article