InfoPath Dev

Hi

I have searched the forum and found numerous posts relating to this question but still can't get it to work. I have an IP 2003 (SP2)form based on an Access DB with additional secondary datasources (xml files).

The form has a repeating table with a drop down list box and a number of text boxes. The DDL gets a value from a secondary datasource (flat) and the first text box is populated with a corresponding value from the same datasource (filtered).

When a row is inserted into the repeating table it takes the value for all subsequent text boxes as the first selection in the DDL.

The formula for the text box is:

xdXDocument:GetDOM("EWC 13")/dataroot/EWC-13/EWC-Code[../Waste = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/d:SWMP-0_Details/d:SWMP-2_Forecast_Waste_13/@Material_Category]

EWC-Code and Waste are fields in the secondary datasource (EWC 13)

@Material Category is the text box

I have tried current()/ and current()/.. in all possible position on the right hand side of the equation (and the left side) and the result is a blank text box.

Has anyone any suggestions.

Thanks

Gary

Hi, Gary:

What field is the drop down list bound to? Not the values, but the list itself? Is @MaterialCategory from your main data source? Is Waste the field with the value you'd like to place, filtered, into @MaterialCategory? Is the formula in the default value for the text box bound to @MaterialCategory?

Sorry for all the questions -- but a little more information would help....I'm sure you've searched the posts, but this from Greg Collins is very helpful.

Hi Hilary

The DDL is bound to @MaterialCategory (main data source) and looks up values from the Waste field in EWC 13 (secondary data source).

The text box, @EWC_No, uses the formula EWC-Code[Waste = @Material_Category] (XPath shown in original question) for the default value and is bound to the main data source.

The value displayed in the text box is EWC-Code, filtered from the Waste value in @Material_Category (part of xml file shown below)

<EWC-13>

<Waste>hydraulic oils</Waste>

</EWC-13>

The filter works fine. If I select 'hydraulic oils' in the DDL, the text box displays '13 01 01*'  but uses the same selection as the first row for all subsequent rows of the repeating table. I can get current() to work if I change the text box to a DDL.

Thanks

 Gary

I would think that EWC-Code[Waste = current()/@Material_Category] would work.... but I'm sure your've tried that. I find it very perplexing that your formula with current() works when you change the control type....I'm sure you do, too! You do have the checkbox Update this value when the result of the formula is recalculated selected, right?

Hi

Yes the checkbox Update this value when the result of the formula is recalculated is selected. I have tried it with the checkbox de-selected as well. I am very perplexed (to put it mildly), all of the forum posts, on this and other forums, say that it should work.

Thanks

 Gary

If your form is something you can share (I realize some companies have policies prohibiting such things) I'd be happy to take a look at it if you'd like to email me. Sometimes a second pair of eyes helps.

Hi

Thanks to the wonderful Hilary Stoupa a solution has been found to this problem.

The use of current()/ or current()/.. as described in the post by Greg Collins http://www.infopathdev.com/forums/p/5493/20643.aspx#20643 does not work with text boxes in IP 2003 but does with IP 2007.

The solution can be found in this link

http://www.infopathdev.com/blogs/matt/archive/2006/04/18/Automatically-Populate-Fields-from-a-Drop_2D00_Down-Selection.aspx