![]() ![]() When you add a query data connection to a form template, by default the forms that are based on this form template use the data connection when they are opened by a user. If you disable this feature, the data will be available only if the user is connected to the network. Security Note: If you are using a secondary data connection to retrieve sensitive data from an external data source, you may want to disable this feature to help protect the data from unauthorized use in case the computer is lost or stolen. Depending on the nature of the data, you may want to display the query results only when users are connected to a network. You can configure each query data connection to save the results so that users have access to the data when their form is not connected to a network. Because the data structure in the secondary data source must match the way that data is stored in the database tables, you cannot modify the fields or groups in the secondary data source. When you add a query data connection to a database, InfoPath creates a secondary data source with data fields and groups that corresponds to the way that the data is stored in the database. ![]() You cannot add a submit data connection to a SQL Server database as a secondary data connection. You add this data connection only if you need data from an external data source other than the one in the main data connection. You can add a query data connection to your form template only as a secondary data connection to a SQL Server database. This data connection can be a query data connection or a submit data connection. To get values from another external data source, you can add a secondary data connection to your form template.Ī secondary data connection is a data connection that you add to a form template. These values may exist in another external data source, such as another SQL Server database. However, the external data source used in the main data connection may not have the values that you want to put in the controls on the form template. InfoPath then creates the main data source for the form template based on the way that data is stored in the external data source. When you create a form template that is based on an external data source, Microsoft Office InfoPath creates a main data connection to that external data source. Step 2: Configure the form template to use the data connection Step 2: Configure the form template to use the data connection If you want your users to use this data connection after the form opens, you can add a rule or a button to the form template to allow users to get data from this data connection. ![]() You can also configure the form template to allow forms to use this data connection when the form first opens. Step 1: Add a secondary data connection to the form template This step creates the secondary data source with the appropriate fields and groups based on the way that data is stored in the database. In order to add a secondary data connection to a database, you must do the following: Find links to more information about adding a secondary data connection to a Web service in the See Also section. If you want to use a secondary data connection to submit form data to a database, use a secondary data connection to a Web service that works with that database. You cannot add a secondary data connection to your form template that submits form data to a database. You can add a secondary data connection to your form template that queries a Microsoft SQL Server database. ![]()
0 Comments
Leave a Reply. |