Query returns all data

[Lasca]

Good day. I have created an access database with an index table for projects,
with a second table for project members. Then I created an infopath form for
reviewing the projects. Part of the form is a query function to screen out
specific projects. One of the variables for the query is the project member.
When I run the query with input to the main table (index table) the query
works fine. As soon as i use input for the secondary table (members table),
the query returns data for all the projects, execpt now it ommits the member
data. Could someone please advise me on what I am doing wrong?

Regards

 

[Swathi (GGK Tech)]

Hi,
What is the input you are using for secondary table? I think the condition
in the where clause you are using is incorrect. Can you send the query that
you are using to get the details of secondary table by filtering the input.

 

[Shiva (GGK Tech)]

Hello,

Whichever you are trying through select statement to get those details from
database check it will work in access database or not. If you will get result
same as your expectation then that same query you have to use in InfoPath.
Make sure that passing values are correct to select statement in InfoPath.