Adding a second criteria to to query in repeating table

[Artunc]

Hello,
I'm just starting to get myself familiar with Infopath and have a quick
beginner question.

I have a form that has repeating table, it queries a SQL database table and
shows all the entries that matches a drop-down box field (which it also gets
the data from a SQL Table)

I need to add a second drop-down box so that it will show the results
matching both selections in those 2 drop-down boxes.

I added the drop-down box right below the first one and I can see the data
when I click to it but when I click to 'Run Query' box, the results are as if
the second criteria has no effect.

How can I combine those 2 boxes and show results that matches to both of them?

 

[Shiva (GGK Tech)]

Hello,

How you are getting the data from database using query statement or stored
procedure? Have you changed your query statement to add second dropdown value
in where condition?

After changing the query statement can you check once that query works in
database or not?

 

[Artunc]

That's what I've been trying to figure out as well. How can I find that out?

When I double-click to the 'Run Query' button, only option is to selec 'Run
Query' action.
I don't see anything there to let me edit or see what this button do in the
background.

Under Tools/Data Connections , I see 3 connections. I looked at each one and
their SQL statement is just simple 'select' commands.