WEB FORM BUILDER SQL SERVER HOW TO

InfoPath also configures the forms that are based on this form template to display a message to users after they submit their completed forms. Top of Page Step 2: Configure the submit optionsĪfter you enable the submit data connection, InfoPath adds the Submit button to the Standard toolbar and the Submit command to the File menu. On the next page of the wizard, select the Enable submit for this connection check box, and then click Finish. In the Data Connection Wizard, click Next. In the Data Connections dialog box, click the main data connection, and then click Modify. On the Tools menu, click Data Connections. Top of Page Step 1: Enable the submit data connection Specify whether to leave the form open, close the form, or open another blank form after the form is submitted. If you want to use a submit data connection to a database as a secondary data connection, use a Web service that works with the database, and then add a submit data connection to that Web service.Īfter you enable the submit data connection, you can also customize the submit options for your form template in the following ways:Ĭhange the text that appears on the Submit button on the Standard toolbar and the Submit command on the File menu.Ĭhange the keyboard shortcut for the Submit button on the Standard toolbar and the Submit command on the File menu.Ĭreate custom messages to display to your users when they submit their forms. You cannot add a submit data connection to the form template that is a secondary data connection to a database.

Note: You can have a submit data connection only in the main data connection to a database.

WEB FORM BUILDER SQL SERVER HOW TO

This article discusses how to enable that submit data connection. If you disable the submit data connection in the wizard and then later you decide that you want to use this submit data connection, you can enable the submit data connection by modifying the main data connection. You can choose to disable the submit data connection in the wizard when you design a form template that is based on a database. If the database meets these requirements, InfoPath enables the submit data connection and adds a Submit button to the Standard toolbar and a Submit command to the File menu on the form. The primary database table that is used in the main data connection contains a primary key, unique constraint, or unique index.Īny other database tables that are used with this main data connection have a simple relationship to the primary database table. To configure a browser-compatible form template to submit data to a database, use a data connection that submits data to a Web service that works with the database. If the form will be filled out by using a Web browser, the form cannot submit data to a database directly. When you design a form template that is based on a Microsoft SQL Server database, the Data Connection Wizard enables a submit data connection to the database if the following conditions are met:įorms that are based on this form template must be filled out by using Microsoft Office InfoPath. Step 1: Enable the submit data connection

Web form builder sql server