Multi-table Query Criteria

[rickyoswald]

I am using the same criteria on several queries;
(SELECT[Field]FROM

)
Where the Field is ID and the Table is tblQryID. A Visual Basic application sends data into the field then any records in the query whos field with the criteria does not match that of the on the criteria points to will get filtered out.
This works absolutely fine provided the query only has fields from one table!

 

[zemp]

I'm sorry, but what is your question?

zemp

 

[rickyoswald]

The criteria works if the query only contains data from one table. If there is more than one table it ceases to work. Why is this?

 

[zemp]

Could be that the tables are not joined properly.

Post your SQL statement and list the tables relationships (PK and FK).

zemp

 

[rickyoswald]

I have three tables; tblQryID, tblClients and tblCases. tblClients holds client info and tblCases holds case information while tblQryID holds a string from a VB app. There is a report called rptClientCases which holds information from the tables tblClients and tblCases, these are connected as one to many. I set up a query that held the criteria for tblClients, field "Name" :
(SELECT[ID]FROM[tblQryID])

So when the VB app sends a string to the field and runs the report it will only show the report with the name that matches that of the string sent by the VB app.
I have used the same query criteria in other parts of my database, they only work if there is one table involved (beside tblQryID). I am using Access 2003 on windowsXP with all the latest updates and such. I have searched on google and such but cannot seem to find anything on it.