Link to home
Create AccountLog in
Avatar of jkeagle13
jkeagle13

asked on

InfoPath SharePoint List Form - Pull Record to Autofill Form

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
Avatar of Jamie McAllister
Jamie McAllister
Flag of Switzerland image

ASKER CERTIFIED SOLUTION
Avatar of Clay Fox
Clay Fox
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer