<div>
Thank you for the quick answer! If i use Web Services, would it be easy too to have whatever response i want? (sorry, i'm not a programmer)<br />
Thanks again!<br />

</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Does anyone know if it's possible and if yes, how we could link a field (single lign of text) in an InfoPath form with a SQL table for data validation? The client's tables have often more than 1000 records so drop down is not an option. Another question is what would be the validation process? When the user click on submit an error message appears beside the filed if it's not correct? Is it possible to activate autocompletion?<br />
<br />
Thank you!
</div>
</div>


Hi,

Does anyone know if it's possible and if yes, how we could link a field (single lign of text) in an InfoPath form with a SQL table for data validation? The client's tables have often more than 1000 records so drop down is not an option. Another question is what would be the validation process? When the user click on submit an error message appears beside the filed if it's not correct? Is it possible to activate autocompletion?

Thank you!

Data validation in Infopath form from SQL table

Microsoft InfoPath is a software application for designing, distributing, filling and submitting electronic forms containing structured data. The product features a WYSIWYG form designer in which the various controls (e.g. textbox, radio button, checkbox) are bound to data, represented separately as a hierarchical tree view of folders and data fields. All the data stored in InfoPath forms are stored in an XML format. Secondary data sources can be built into the form or they can be accessed through an external data connection to SharePoint or a Web service.

InfoPath

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.