InfoPath Dev

I am trying to create a “display” only form in InfoPath 2010 that pulls data from a Sharepoint list. My list has 15 columns of data and is also quite large.  What I am trying to do is display 3 of the columns in drop down lists (distinct). When this is selected only the data that matches shows up in the repeat table below. I am using the same sharepoint list for the dropdown and also for the repeat table.

1.       I am able to create the drop down and associate it to the list and pull back the data. ( I set this to automatically pull data on the load)

2.       I am not able to set a condition to pull back where data matches to display only those in the repeat table. (I created another connection to same list but not to load data)

I tried setting up a rule to “query” data when field 1 = sharepointlist field 1 or field 2 = sharepointlist field 2, etc and it does not work.

Any suggestions on how to do this? or am I missing something in the conditions

Hi,

This is the basic set up you'll need.

- One data connection that executes on load and populates the dropdown (returns only whatever data is needed for the dropdown).

- Rules on the dropdown to: (a) set the value of the query fields and (b) query a second data connection (which returns the columns you need)

- Then you can display the results of this second data connection.

Now, when configuring the dropdown, remember that dropdowns have a DisplayName and a Value. Value is usually the ID column of the SharePoint list, and this will be needed for the second data connection, in order to complete the query correctly.

Hope this helps. Good luck!