https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/99299.aspxFri, 26 Sep 2014 14:22:00 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:99299Kully0https://www.infopathdev.com:443/forums/thread/99299.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=99299<p>Hi, </p><p>I am trying to create a&nbsp;InfoPath 2010 form, which I am connecting to a SQL server. I have connected&nbsp;to the appropriate table.&nbsp;I have two text fields on the form i.e. Username and Password. </p><p>I&nbsp;would like to check if the data which is entered in these fields matches&nbsp;the data in the database once&nbsp;the submit button is clicked. If it does then it takes the&nbsp;user to a different view i.e allows them to access the next page. </p><p>&nbsp;E.g. the database contains 2 columns Username and Password. - Record 1 Username = test1, &nbsp;Password = 1234, Record 2 Username = test2, Password - 3456</p><p>&nbsp;If a user enters both matching username and&nbsp;password from the database then this takes the user to another view however if they do not match then user is presented with an invalid log in error message. </p><p>Any advise on&nbsp;how I could achieve this will really be appreciated. </p><p>Thank you in advance. </p><p>&nbsp;&nbsp;</p><p>&nbsp;&nbsp;</p>