<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Browser Forms</title><link>https://www.infopathdev.com:443/forums/40.aspx</link><description>For browser form specific questions</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Create a search-find-choose option from external list.</title><link>https://www.infopathdev.com:443/forums/thread/94755.aspx</link><pubDate>Thu, 12 Dec 2013 22:16:20 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:94755</guid><dc:creator>daniel.christian</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/94755.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=40&amp;PostID=94755</wfw:commentRss><description>Greetings,
I am attempting to create an InfoPath web-based form where users can come, fill the form and submit it. One field of this form is a search where a user types in text, clicks search and chooses the correct finding.

I have gotten most of it already done except for the search piece. Here is my current setup.
I have two lists on SharePoint, one is a custom list and the other an external list being pulled from a SQL database. The external list is a BDC using the Wildcard filter type.

At first I attempted to simply add an external list item to the original custom list and work with the SharePoint list add/edit view. It worked well except for the convoluted process of a user, having to click the &amp;#39;Select External items&amp;#39; option, a separate window populates, do the search and then pick the item. 

I&amp;#39;m trying to create a cleaner, easier form using InfoPath. 

I have created an InfoPath form using the custom list and then added the external list as a data connection.

I want to search the external list, find and select what I am looking for, fill the rest of the form manually and then submit it.

Has anyone attempted this before? 

Currently, my external BDC with the wildcard filter doesn&amp;#39;t give results when I do a search on infopath. 
I created another external BDC (without the wildcard filter) but when I do a search, what I type in has to be exact otherwise I don&amp;#39;t get any results.

In short, I&amp;#39;d like to use the external bDC with wildcard filter, search-find-choose.

Thanks in advance for your help.</description></item></channel></rss>