O'Reilly logo

Beginning InfoPath™ 2003 by F. Scott Barker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

8.4. Specifying Filters on InfoPath Forms

When working with data located in a Web service or database you can limit the amount of data, or filter, by using the query fields. There are times when it is convenient to limit data when using a standalone form as well. One way to do this is to specify filters, which can be done for a whole form, or individual repeating tables.

The way to accomplish filtering is by setting the Filter Data properties on a repeating table or section, located on the Display table in the property sheet, and pointing them to another control containing the values to filter for, such as a drop-down list box. You can see an example of this in Figures 8-11 and 8-12, where first all records are displayed,

Figure 8.11. Figure 8-11
Figure 8.12. Figure 8-12

8.4.1.

8.4.1.1. Try It Out: Filtering a Repeating Table Using a Drop-Down List Box

For this task, you will make a new blank InfoPath form that will create a list of employees with their type.

  1. Open InfoPath.

  2. Click on Design a Form.

  3. Click New Blank Form....

  4. Add a Repeating Table control from the Repeating and Optional section of the Controls task pane. The Insert Repeating Table dialog box will open, as shown in Figure 8-13, with the default value of three columns displayed.

    Figure 8.13. Figure 8-13
  5. Click OK. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required