I've read several articles about this but they all assume knowledge I don't have I think because I've yet to get it to work once I get to the Fx section.
I have a data source of a sharepoint list called InfopathTest. The list has two columns ID and Name.
I create my infopath form and connect the data source using the receive data connection, find infopattest and check mark both ID and Name.
Now I want a drop down list that populates off the ID column. Once the ID is selected I want a text box to populate with the name associated with that ID.
I put a drop down list box in the form and a text box. I rename the two controls to ID and Name respectively.
In the ID control properties I look up values from external data source, check ID, select the ID field. Good so far the drop down does populate with the list of ID's.
Now is where I run into the problem. Using the Name control (text box control) I create a rule, have it "set a fields value". In the "Field" choice I click on the xpath button, and change the source to infopath(secondary). I have two choices of ID and Name there but I don't know which one to pick, or what to do past this point when I get to value and FX.
There must be someway to refer the text box control (name) to check the ID box then provide the Name that is in the corresponding ID row in the sharepoint list but I'm completely lost at this point.
Thanks for any help you could provide.
JG
** Edit, I did get a little further, from the ID dropdown I selected a rule, Action: set a fields value, Field: set it to the text box field, Value: I pointed this to the name column from my data source. As soon as I pick an ID it fills in the first name on the list, but regardless of what ID I choose it still shows the name of the person in the first row of my data source (
** Nevermind I finally figured it out, in the rule filter I was setting the 2nd condition to the sharepoint list column when I just needed to point it to the dropdown field identifier, works perfectly now.