Examples of using Main data connection in English and their translations into Vietnamese
{-}
-
Colloquial
-
Ecclesiastic
-
Computer
Working with the main data connection.
You can select multiple database tables andestablish table relationships just as you would for the main data connection.
All of the tables in the main data connection must contain a primary key, unique constraint, or unique index.
You cannot connect to a library or list through a main data connection.
Any other database tables that are used with this main data connection have a simple relationship to the primary database table.
You add a secondary data connection only if you cannot query orsend data through the main data connection.
The primary database table that is used in the main data connection contains a primary key, unique constraint, or unique index.
You add this data connection only if you need data from anexternal data source other than the one in the main data connection.
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.
When you create a form template that is based on a database,InfoPath creates a query data connection as the main data connection between the form template and the database.
There can be only one main data connection for a form, and it is created automatically when you create a form template that is based on an external data source.
If your form template meets the requirements in the Overview section, the Summary section on this page of the wizard indicates thatInfoPath enabled the submit data connection in the main data connection.
When a form that is based on this form template uses the main data connection, InfoPath creates a query by using the data in the query fields.
If the main data connection connects to an external data source, how you work with the main data connection depends on the type of data source that it connects to.
If InfoPath disables the submit data connection, the main data connection for your form template will contain only a query 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.
A form can have one primary data connection, called the main data connection, and it can optionally have one or more secondary data connections.
If your form template and the tables that you selected in the Data Connection Wizard meet the requirements in the Overview section,InfoPath configures your form template to submit data by using its main data connection.
You can disable the submit data connection in the main data connection if you want users to submit their form data through a different data connection. .
When you design a new form template that is based on a database, Web service, or settings in a connection library,you create a query data connection that becomes the main data connection for forms that are based on that form template.
A form can submit data to a database through the form's main data connection if the form template that the form is based on and the database meet the following requirements.
Secondary data connections are useful when you need to query or submit form data to an external data source other than the external data source in the main data connection, or when you want users to submit data to multiple external data sources.
If you want to connect a form to a database, and the main data connection has already been created for the form, you can add a secondary data connection that queries the database.
Web service When you design a form template based on a Web service,you can create a main data connection that both queries and submits data, only queries data, or only submits data. .
This data connection is different from the main data connection that is created when you design a form template based on a database, Web service, or settings in a connection library.
When you design a new form template that is based on a Web service,InfoPath creates a main data connection to the Web service and then creates a main data source that contains query fields, data fields, and groups that match the XML Schema of the Web service.
Depending on your goals for the form, you can create a main or secondary data connection to an external data source, such as a Microsoft SQL Server database or a Web service.
A form can query orsubmit data to a Web service through either a main or a secondary data connection.
A form can query data from a database through either a main or a secondary data connection, and you can select any number of database tables for a connection. .