https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/85626.aspxWed, 26 Dec 2012 08:35:35 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:85626Mel Clemente0https://www.infopathdev.com:443/forums/thread/85626.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=85626I believe you will need a web service for this. Try Qdabra&#39;s DBXL web service - it has a method called QueryDB. You can add rules to your ID field that queries SQL with that specific ID. A free trial is available <a title="Qdabra DBXL" href="http://www.qdabra.com/en/products/DBXL.aspx" target="_blank">here</a>. Contact us if you need further assistance setting it up.https://www.infopathdev.com:443/forums/thread/84211.aspxTue, 06 Nov 2012 20:18:08 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:84211nemo3850https://www.infopathdev.com:443/forums/thread/84211.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=84211<p>Hi,</p><p>I have a web based IP 2010 form that has a n ID field which is a textbox. When a user enters an ID in the textbox, I want to first check if that ID is in the SQl table or not. If yes then only fetch the values in some other fields. Else display a custom error message saying the ID doesn&#39;t exist. Please let me know how could I achieve this? Thanks.</p>