InfoPath Dev

Hi!

I'm not an advanced InfoPath user and I'm having a problem that I'm hoping someone here can help me with.

I have an InfoPath form that has a data connection with a SharePoint list. My goal is to have a form that, upon opening, checks the list, gathers parameters, and populates/creates as many repeating sections as it needs to based on a field.

For example:

Say in my sharepoint list I have 3 columns: Number (key), Type, Color.

The example values are as follows: 

I want to create a unique InfoPath form that always looks at this list and pulls the associated values for all "yogurt" fields. Right now, my form pulls the first row of information in the list regarding yogurt (Number: 4 --- Type: yogurt --- Color: blue). However, I when I click the "new item" button for the repeating section, it just adds the exact same values (that is, the first yogurt row over and over). I would like it to move down each unique row and I want it to automatically add new sections (and populate the fields) for each unique yogurt instance.

Can this be done?

I appreciate and thank you very much before hand for your help!

 Is this SharePoint 2010 or 2007?

SharePoint 2010.

Sorry I forgot to mention that earlier. Also InfoPath 2010.

SharePoint 2010 allows query parameters, so you could set the query parameter for Type='yogurt', then execute the data connection, and the data fields that are returned will be prefiltered.

Can you try this?

I am able to query the incoming data connection to 'yogurt'. My problem is that the fields auto-populate with the first version of yogurt only (Number: 4 --- Type: Yogurt --- Color: blue). When I try to add new sections (as the fields are in a repeating section), it keeps returning only the very first instance of yogurt. Ideally, I'd like it to list every unique instance of yogurt automatically (without me having to click the 'add new' on the repeating section).

What about the secondary data source - does that have the correct data?

I guess I misunderstood; do you want this data to be loaded into a repeating table in the main data source?

Hello,

I am in exactly the same situation. I have a list with data, which I want to populate in a form with repeating table.

As the list grows, I want the the form to automatically add new entry in the repeating table. Currently it adds only the

1st entry of the list. Please help.