InfoPath Dev

Hello,  I am creating a form for employee testing and need to perform some validation. In the past we've had incidents of people not being able to recall their employee number, first name in last name and so on. I currently have a list of all those facotrs broken down and would like to make sure that the first name entered is the first ...

I am currently doing some data analysis using infopath as the input for all of our information. Based on one fields value I have created values that auto-populate. Such as if the number is great than 180 than two other fields auto-populate with "High" and "0". The problem I am running into however is that if I type in the wrong ...

My company has created out form and connected to the SQL server, however when we query we get a select all query. How do we set this up so it only queries the invoice number we have added. AND How can you set up InfoPath to create a new form if the invoice number is not correct? Thanks!

First question - we are testing our new InfoPath and SQL connection. When I query our test results, all the data return in the query and not just the invoice number we are looking for. How do I fix this?  Second question - is there any way to better secure password with infopath? It mentions that it is storing the files as a plain-text ...