Share this Page URL

Chapter 15. Integration with Office 2003... > Working with Access Data in InfoPath - Pg. 548

Integration with Office 2003 and SharePoint Services 548 8. 9. 10. You'll notice that InfoPath defaults to having the Show Table Columns check box selected. This allows you to see all the columns in the table and select which columns you'd like to use in your form. You also can edit the SQL statement that selects the table columns. For this example, leave all of the columns selected. Click the Next button. The final screen of the Data Source Setup Wizard provides a summary of the settings you just made in the wizard. You can also specify which view will be displayed when the wizard closes: Query Form view or Data view. InfoPath forms that are based on a data source have these two views, which are related to the type of work the form can do. Query Form view will allow you to conduct searches against the database and return a record based on the criterion (or criteria) you enter. InfoPath displays the record in Data view, so in a sense, Query Form view doesn't accomplish much without Data view. Data view will allow you to create new records and add data to the table. The wizard will create Query Form view for you and leave it to you to create Data view. If you expect to use the form only to enter data, not to look up data, select the Data View option. If you think you'll need to do both, you might want to select the Query View option and design Data view on your own. In the Do You Want To Open The Form To Design The Data View Or The Query View First? section, select either the Data view or the Design Query view, and then click Finish. You now have an InfoPath form that is based on (and linked to) your Access table. You will have to actually design the Data view portion of the form. InfoPath creates all the data links; all you have to do is lay out the form. You can save the InfoPath template to your documents folder or publish it to an intranet or Internet Web site. Linking to Access from an InfoPath Form