March 2005
Beginner to intermediate
378 pages
8h 46m
English
Content preview from Beginning InfoPath™ 2003
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
4.1. Starting the Form Based on a Data Source
When creating forms based on data, the data that is to be used with the form needs to be specified. This does not mean merely which database you want to use, but also the tables or queries, and even the fields. While the InfoPath team has been kind enough to give us a wizard to connect to data sources, there are specifics you need to understand to have the correct data available for use on your InfoPath form.
4.1.1. Specifying the Right Data for the Right Job
When using more than one table for a form, all the tables necessary must be chosen. For example, if you wanted to list customers and their invoices with details, you would choose tblCustomers, tblInvoices, and tblInvoiceDetails. For this chapter, you will be use a Microsoft Access table from the Chapter 4.mdb titled tblCustomers. You can see some data from this table displayed in Figure 4-1.
Figure 4.1. Figure 4-1
To make it simpler all the data from this table will be used. If using only a few fields from a table, then only those fields should be specified. The Data Connection Wizard guides you in making these choices.
4.1.2. Working with the Data Connection Wizard
The Data Connection Wizard steps you through accomplishing the following tasks:
Pick a Database: Besides picking the type of database (for example, Access, SQL Server, or Web service), the actual database can be ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.