InfoPath Dev

Hello

This may seem like something very easy but I just can't get it working correctly.  I have a text box field and a submit button setup.  The submit button takes the data from the textbox and I want it to check a particular table in a SQL DB, and if the number is there to display some static numbers. 

Here is what i have so far

Conditions

JobNumber is equal to WBS1 (SQL DB field)

Actions: Query using a data connection: sql db

Set a field's value airfare = @airfareamount

When i press the submit button all 0's are placed in the static field and I know there is a true number in there since I placed in the number

Any ideas?
 

So the problem is you are getting the values from the very first record not the one selected?

A filter is what you need to say set the values but where jobnumber = WBS1.

When selecting @airfareamount use the filter button and add WBS1 = JobNumber

That way you get the data for the correct record.

I work with databases and InfoPath every day.

If you want to email me I could show you some examples.

 Clay

I just shot you an email 

Can someone please look at my code to see where I went wrong please 

xdXDocument:GetDOM("Vision Database")/dfs:myFields/dfs:dataFields/d:ProjectCustomTabFields/@custReimbursibleMaxRateAir[../@WBS1 = xdXDocument:get-DOM()/my:travelRequest/my:JobNumber]