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?