InfoPath Dev

I have two infopath forms & libraries on my sharepoint that contain related data. One library is used to track revisions/additions to the original form in the other library. Due to legal constraints, the original data must stay intact. I can populate a drop down to set key fields in the 2nd form to the values that they contain in the first ...

Sorry for the confusion. I have read the article you suggested and have attempted to follow the instruction but I end up with the same result. I'm using a seconday data source which is called Commodities and provides the link to the Oasis_Commodities Sharepoint List which contains the columns Category and Commodity. I click on the on the x-path ...

I apologize if this is a redundant question. I've read several other posts on this subject, but I still can't quite find one that fits my scenario or make any of the solutions work for me. I have a drop down in my form which gets its values from a list on the sharepoint. The data is essentiall a flat data source with two columns; Category and ...