You can only add fields or groups to the root group in the main data source. The results of the query are put into data fields, which can be edited through controls that are bound to these fields.īecause the data structure of the query and the data fields must match the way that data is stored in the database, you cannot modify these fields or groups in the main data source. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |