VLOOKUP???

[rchorner]

Total newbie here, please excuse me. I've bound a drop down control in my
form to one of the fields in an external LIST within my sharepoint site that
has multiple columns of data. My question is: how can I automatically
populate other fields (read-only) on the form with other data elements
(columns) from the LIST?

If I were doing this in excel, I'd just do a VLOOKUP. Any ideas???

 

[Bruce Anderson]

What worked for me was to add an Expression Box control. The DataSource had
XPath:

xdXDocument:GetDOM("TestLookup")/ns1:myFields/ns1:entities/ns1:value[../ns1:key = current()/my:id]

I was able to build most of this XPath using wizard, but then had to edit
the XPath by inserting the current() reference.

Hope that helpls.

 

[rchorner]

Thanks, Bruce. I also found a very helpful link on this subject that walks
you through, step by step, with screenshots. My form is complete!

http://www.wssdemo.com/Pages/infopath_lookup_of_list_data.aspx?menu=Articles

What worked for me was to add an Expression Box control. The DataSource had
XPath:

xdXDocument:GetDOM("TestLookup")/ns1:myFields/ns1:entities/ns1:value[../ns1:key = current()/my:id]

I was able to build most of this XPath using wizard, but then had to edit
the XPath by inserting the current() reference.

Hope that helpls.

Total newbie here, please excuse me. I've bound a drop down control in my
form to one of the fields in an external LIST within my sharepoint site that
has multiple columns of data. My question is: how can I automatically
populate other fields (read-only) on the form with other data elements
(columns) from the LIST?

If I were doing this in excel, I'd just do a VLOOKUP. Any ideas???