InfoPath Dev

I am trying to figure out how to get the current item of a repeating group that is nested within another repeating group.  Can anyone help with the xpath for this?

My structure in my InfoPath form looks something like this:

• Assembly_Item (repeating group)
• my:Part_Families (group)
• ns1:Purchased_Part (repeating group)
• my:Component_Name (user selected from drop down menu)
• my:Price_per_Unit (calculated in background)
• ns1:Raw_Material (repeating group)
• my:Material_Name (user selected from drop down menu)
• my:Price_per_kg (calculated in background)

I also have a secondary data souce, which is a SharePoint list, with the data that I need to filter.  There is one list with a column for "Component_Name" and a corresponding "Price_per_Unit", as well as a list with columns "Material_Name" and "Price_per_kg".

The question, using this example, is how to get the current field for the "Component_Name" and "Material_Name" fields to use for filtering the corresponding secondary data sources to get "Price_per_Unit" and "Price_per_kg", respectively.

Thanks!

Nick22

Are you using IP 2003 or 2007? Do you want the Price_per_kg to be a calculated default? Or is its value set by a rule on the Material_Name?

IP 2003.

Price_per_kg is something I assume has to be a calculated default because it is in a repeating group.  If I use a rule on Material_Name, it sets all instances of Price_per_kg to one value.  The functionality that I need is to have (0 to unbounded) instances of "Raw_Material" with independant Material_Name values with their corresponding Price_per_kg values from the secondary datasource.  In other words, I need it to function like a VLOOKUP in Excel and for it to be updated automatically.

If I recall correctly, current() didn't work correctly in default values for IP 2003. You'll need to use a rule. It appears to me from your schema outline that Material name is in the same repeating group as Price per kg? Can you just attach a sample of your template? Under the Options tab, there is a place to attach a file...

I was afraid of that with the current() funtion not working well in IP2003.

I am a bit skeptical that rules would work in this situation as the repeating sections have fields that are based on other data fields of that instance, and a rule would set all values in a repeating section to the same value, which would not work.  EX: Sub-total of Material price is dependant on Material (drop down) and length (entered value), which can be different for each instance.  If it is any help, while in theory there could be between 1 - unbounded instances, there are mostly only between 1 and 5 in practice. 

I am curious to hear your thoughts you see a work around for IP2003.

Many thanks again for your help!

-Nick

Just wanted to catch the thread up with the resolution -- in IP 2003, we need to use rules with the current() function -- it doesn't seem to work in default values.