<?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>General</title><link>https://www.infopathdev.com:443/forums/41.aspx</link><description>If you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Database Connection/SQL problem</title><link>https://www.infopathdev.com:443/forums/thread/68135.aspx</link><pubDate>Wed, 06 Jul 2011 16:21:45 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:68135</guid><dc:creator>trixter76</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/68135.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=68135</wfw:commentRss><description>Hi all - 

   Been reading over this forum a good bit over the last few days, but I&amp;#39;ve been unable to find an answer to my current problem.  I&amp;#39;m attempting to create an InfoPath 2007 form that will allow a user to enter multiple model numbers and then retrieve a specific value based on that number.  

- I currently have A SQL connection setup correctly and I&amp;#39;ve edited the SQL to reflect the specific columns that I want returned
- I have tried retrieving my values two ways:
  1.  Create two text boxes.  In first text box user enters model number; second textbox is read-only and I have a rule in first text box to populate this field.  
  2. I have a &amp;#39;Submit&amp;#39; button that essentially does the same thing as the above, but I am having the same problem with it.

To test it out I am entering a number in &amp;#39;Model Number&amp;#39; and attempting to assign the field I want (ID Field) to the other read-only text box by filtering for form model number = model number in database and display the ID associated to this model number. 

Any help would be greatly appreciated as I&amp;#39;ve been banging my head against the computer for the last several hours attempting to get this to work.  

Thanks,

Trent</description></item></channel></rss>