One of my applications is using tables from an Access database. The tables have a many-to-many relationship that is dealt with by using a Junction table, see below:

Name: TableView.jpg Views: 733 Size: 81.3 KB
In the Junction table of the dataset I have setup the following query:

SELECT tblSourceMaster.intSiTechID, tblSourceMaster.strVendorName,tblSourceMaster.strVendorID
FROM ((lnkItemVendor
INNER JOIN tblItemMaster ON tblItemMaster.intSiTech = lnkItemVendor.intSiTechItemID)
INNER JOIN tblSourceMaster ON tblSourceMaster.intSiTech = lnkItemVendor.intSiTechVendorID)
WHERE (lnkItemVendor.intSiTechItemID = ?)

I call the query from a button event in a form:

LnkItemVendorTableAdapter.FillBySiTechItemID(Me._MasterBase3_0ItemMasterDataSet.lnkItemVendor, glbintIDNum)

I get the following error:

Name: relatedTables.jpg Views: 702 Size: 58.6 KB

I can see that the problem is with the two joins after the equal signs. However, I cannot understand why there is no value there. Can anyone explain to me what I am doing wrong. Anything beyond a simple query is not my strong suit.