Hi. I am new to infopath and i have been searching for an answer to this question for a couple days and i might have missed something but haven't seen anything that is quite what i need. I have a field with a list of vendor names that retrieves data from a sharepoint list. However, some vendors have similar names, and people tend to just pick the first name they see, or they might not know the full name of the vendor. For instance we have two sepearate vendors, one is named 3M Cogent and the other is named Cogent Inc. Most people would just pick the Cogent one, not realizing they really mean 3M Cogent. To prevent this from happening i wanted to have to fields on my infopath form. One is a text box where they can type part of the vendor's name and then a list box (or combobox or anything that would achieve the same thing) below it would show all the vendors that contain part of that data. Kind of like the "custom" filter options in excel and sharepoint list (when in dataview). However, when i use a contains filter condition and you type more than one letter it shows blank. I have tried building filters on Sharepoint but because our IT department isn't familar with Sharepoint but won't let anyone else have designer i can't do much with it because it is 2007 version. So, i am trying a work around. I thought it would be simple but it is not.
I have tried dragging everything i could onto the form to see if i was putting the wrong values somewhere but nothing loks wrong. I am just hoping someone can help.
Basic layout:
Sharepoint list that has the following fields/: ID(auto generated) ; Vendor Name; VendorID; VendorNameAndID - The Vendor name and ID is text not a formula.
Infopath has a VendorName and Vendor Name and ID field. Employee would type part of the vendor name in the text box, then the Vendor Name and ID field would populate with any information containing it.
The infopath is connected to a SharePoint library where it will be stored.
Any help or guidance would be greatly apprecaited.