Hi Adam,

Please test the following steps (these use the Northwind sample SQL Server
database.)

- Create a new, blank InfoPath form
- Add a Repeating table with 2 columns
- Change the name of text box in the first column to: txtCategories
- Change the name of the text box in the second column to: txtProducts
- Add a new "receive" data connection to the Categories table in the
Northwind sample database (you only will need the CategoryID and
CategoryName fields)
- Add a new "receive" data connection to the Products table in the
Northwind sample database (you only will need the ProductID, ProductName
and CategoryID fields)
- Right-click on both txtCategories and txtProducts, choose Change To and
select Drop-Down List
- Right-click on txtCategories and choose Properties
- For the List Box Entries, choose the option "Look up values in a data
connection to a database..."
- From the Data Connection box choose Categories
- Click the Select XPath button next to Entries and choose d:Categories
- Leave Values as "@CategoryID" but click the Select XPath button next to
Display Name and select CategoryName
- Right-click on Products and choose Properties
- For the List Box Entries, choose the option "Look up values in a data
connection to a database..."
- From the Data Connection box choose Products

** Now we begin to filter! **

- Click the Select XPath button next to Entries and choose d:Products
- Click the Filter Data button
- Click Add
- In the first drop-down box choose CategoryID
- In the second drop-down box leave the default: is equal to
- In the third drop-down box choose Select a Field or Group
- From the Data source box choose Main
- Expand the groups until you can select txtCategories and then click OK
- Click OK again
- Click Modify
- From the first drop-down box choose The expression - you should then see
the following:

@CategoryID =
xdXDocument:get-DOM()/my:myFields/my:group1/my:group2/my:txtCategories

- Modify this to the following:

@CategoryID = current()/my:txtCategories

- Click OK until you are back to your form

** Now we need to clear out the Products list after each selection

- Right-click on txtCategories and choose Properties
- Click the Rules button
- Click Add
- Click Add Action
- From the Action box choose Set a field's value
- Click the button next to "Field" and choose txtProducts
- Leave the Value field blank!
- Click OK 4 times to get you back to your form
- Preview and test by adding rows to the table - each time you select a
category the products list should be refreshed and only include those
products that match the selected category!

Let me know how this works for you!

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights