• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 26. Integrating with InfoPath an... > Designing an InfoPath Query and Data...

Designing an InfoPath Query and Data Editing Form

InfoPath has a set of built-in operations for database query and editing operations. When you specify a database table or query as the primary data source for the form, InfoPath automatically generates a form with two views of the data. The query view is remarkably similar to Access’s Filter by Form feature. You type one or more exact values to match in the view’s text boxes; the query view doesn’t accept wildcards. Data entry view displays records that match the query values. You can restrict the data entry view to display a single record or deliver multiple records to a repeating section. If the data source is updatable, you can add new records to the table(s) in data entry view.

InfoPath lets you save query and data entry views locally in the form’s XML document. Local storage lets users work with the data while they’re offline, edit the data, and then submit the changes when they reconnect to the network. In this respect, InfoPath data editing process emulates ADO’s batch-optimistic updating feature.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint