Beginning InfoPath™ 2003

4.4. Updating a Form's Data Source

No matter how well you plan out your forms and the data you base the forms on, there will be many times when you need to modify the data source for a form. Hopefully, you will only be adding a couple of fields to the form that already exists in the database. If you need to modify objects in the database itself, you need to open the database, in Access for example, and modify them there, and then modify the data source in InfoPath.

When you need to modify the data source for a form in InfoPath, use ToolsData Connections. A dialog box listing the current connections used by the form will displayed, as shown in Figure 4-17.

Figure 4.17. Figure 4-17

After highlighting the connection you want to use and clicking Modify, the Data Connection Wizard will be opened again. At that point, you can make your modifications that you want to make. There are a number of ways you can make modifications to the data source. For example, if you want to add a sort order to a table you can use the Edit SQL . . . command or choose the Modify Table command, both on the Data Connection Wizard.

Which command you use will depend on if you are comfortable with working with SQL statements directly or not. If so, then use the Edit SQL . . . command. If you are just adding a ...