<div>
You can call web services from InfoPath;<br />
<br />
<a href="http://sharepointsource123.blogspot.ch/2012/02/nsuming-listasmx-web-service-using.html" rel="ugc">http://sharepointsource123.blogspot.ch/2012/02/nsuming-listasmx-web-service-using.html</a><br />
<br />
If you have Claims Based Auth enabled you'd also need to refer to this;<br />
<br />
<a href="http://blogs.msdn.com/b/russmax/archive/2012/08/17/want-to-call-sharepoint-2010-web-services-within-browser-based-infopath-2010-forms.aspx" rel="ugc">http://blogs.msdn.com/b/russmax/archive/2012/08/17/want-to-call-sharepoint-2010-web-services-within-browser-based-infopath-2010-forms.aspx</a>
</div>


You can call web services from InfoPath;

http://sharepointsource123.blogspot.ch/2012/02/nsuming-listasmx-web-service-using.html [http://sharepointsource123.blogspot.ch/2012/02/nsuming-listasmx-web-service-using.html]

If you have Claims Based Auth enabled you'd also need to refer to this;

http://blogs.msdn.com/b/russmax/archive/2012/08/17/want-to-call-sharepoint-2010-web-services-within-browser-based-infopath-2010-forms.aspx [http://blogs.msdn.com/b/russmax/archive/2012/08/17/want-to-call-sharepoint-2010-web-services-within-browser-based-infopath-2010-forms.aspx]

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have a SharePoint 2010 list with a number of different fields. I'll call it the main list. I am using InfoPath to edit the NewForm.aspx page.<br />
<br />
I have a second list that I use simply for storage. It links a serial number to the name of a product. There are just two columns, Serial Number, and Product Title.<br />
<br />
In my main list, I ask the user for a serial number. I want to have an InfoPath rule such that when a user enters a serial number into the serial number, if it exists in the other table, it will look it up from the other table and autofill the product title for the user in the main list.<br />
<br />
Can someone point me in the direction of the rule formula/code I would need to accomplish that?<br />
<br />
Thanks!<br />
Joseph Irvine
</div>
</div>


Hello,

I have a SharePoint 2010 list with a number of different fields. I'll call it the main list. I am using InfoPath to edit the NewForm.aspx page.

I have a second list that I use simply for storage. It links a serial number to the name of a product. There are just two columns, Serial Number, and Product Title.

In my main list, I ask the user for a serial number. I want to have an InfoPath rule such that when a user enters a serial number into the serial number, if it exists in the other table, it will look it up from the other table and autofill the product title for the user in the main list.

Can someone point me in the direction of the rule formula/code I would need to accomplish that?

Thanks!
Joseph Irvine

InfoPath SharePoint List Form - Pull Record to Autofill Form

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

Microsoft InfoPath is a software application for designing, distributing, filling and submitting electronic forms containing structured data. The product features a WYSIWYG form designer in which the various controls (e.g. textbox, radio button, checkbox) are bound to data, represented separately as a hierarchical tree view of folders and data fields. All the data stored in InfoPath forms are stored in an XML format. Secondary data sources can be built into the form or they can be accessed through an external data connection to SharePoint or a Web service.

InfoPath

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.