Connecting to Microsoft Access
Many organizations that depend on Microsoft Access as a data store for departmental and other sub-corporate databases will find InfoPath 2003 a useful alternative to Access forms for many purposes. For some simple scenarios, it's sufficient to create an InfoPath form template similar to the example shown in Chapter 1, “Getting Started with InfoPath.” In Chapter 1 you saw how a form template can be created to both query an Access database and submit data to an Access database.
Using Multiple Tables in a Form
InfoPath 2003 has some functionality to enable form templates to query ...