The database returns the results of the query back to the form through the query data connection. InfoPath then sends the query through the query data connection. ![]() When a form based on this form template uses the main data connection, InfoPath creates a query by using the data in the query fields. Query fields contain the data that is entered by a user to limit the query results to records that match the data in the query fields. ![]() ![]() These fields and groups correspond to the way that data is stored in the tables in the database. When you design a form template that is based on a database, Microsoft Office InfoPath creates a main data source with groups that contain query fields and data fields and a query data connection as the main data connection for the form template. Depending on your goals for the form, a data connection might query or submit form data to an external data source, such as a Microsoft SQL Server database or a Web service. In this articleĪ form can have one primary data connection, called the main data connection, and it can optionally have one or more secondary data connections. ![]() You can design a form template that can work with a Microsoft SQL Server database to either query data or query and submit data.
0 Comments
Leave a Reply. |