InfoPath Dev

hello all,

 i have set up an xml file so that drop downs automatically filter. it 4 levels deep.

          location
               product
                     ingredient
                             code

the first 3 are drop downs, and filter just fine, so if i pick a specific location, only those products show up and so on, so forth (using xml, and filter properties)

 the problem is for my "Code" i want a read only text box that popultes depending on the ingredient picked, the xml file usually only has one code for each ingredient, but sometimes more than one, but they are all the same when they duplicate. i went into the text box properties and did the FX and selected the options the same way as i did the drop downs, but it does just not seem to work. the forumala for the text box ended up as "Code[@IngredientName = Ingredient]" (i did check update the value when result is recalculated)

 so i am lost, any ideas?
                 

Hi Gagan,

May have to do with the xpath axis not being correct (in other words, it doesn't get the right Ingredient). Check out Greg's blog entry on Axis: http://www.infopathdev.com/blogs/greg/archive/2005/06/13/Using-XPath_2700_s-_2700_preceding_2D00_sibling_2700_-Axis-Correctly.aspx

Another way to do this is to just set the field. Add a rule to the 3rd dropdown that sets the field of the 4th. When you choose the 4th field to set you'll get a filter button in the lower left corner of the dialog. Use that and you may not have to worry about writing your own xPath.

Hope this helps!