Infopath 2003 , Sharepoint 2.0
Hi,
I have a clothing inventory stored in a sharepoint list. There are columns for Item Description, Unit_Price, Available_Sizes etc ...
What I'd like to do is have a repeating section where users can select the Items from the Sharepoint site via a dropdown box. Once the item is selected, I'd like the other two fields to populate with that items price and a dropdown of available sizes. I cannot get this to work.
I set the Price field to pull from the Sharepoint list with a filter set to the Unit_Price field with the following filter: Item Description= current()/my:Item If the Price field is a textbox, nothing happens. If I change it to a dropdown or list box, the price appears but the default is blank and you need to scroll down to see the price. If you then put a Set Field action on the Item dropdown box, it again does nothing if the Price field is a text box but will set the default to the price if the field is changed to dropdown or list. This only works for the first repeating section though, the next section will have the price set to the price of the Item in the first drop down section.
Can anybody see what's going wrong?
Many thanks.