<?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>Microsoft Access</title><link>https://www.infopathdev.com:443/forums/141.aspx</link><description>Qdabra is committed to answering InfoPath questions. However, we do not support Microsoft Access. For non-Access questions, please use the other boards.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Re: Pull data from Database based on value from Database</title><link>https://www.infopathdev.com:443/forums/thread/79311.aspx</link><pubDate>Thu, 07 Jun 2012 07:42:36 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:79311</guid><dc:creator>Patrick Halstead</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/79311.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=141&amp;PostID=79311</wfw:commentRss><description>&lt;p&gt;This isn&amp;#39;t supported out of the box. &lt;/p&gt;&lt;p&gt;You can use our qRules or DBXL accelerators to do this. qRules is a plugin and DBXL is a Web service. Unfortunately, neiter of them work with Access.&lt;/p&gt;&lt;p&gt;Sorry,&lt;/p&gt;</description></item><item><title>Pull data from Database based on value from Database</title><link>https://www.infopathdev.com:443/forums/thread/79229.aspx</link><pubDate>Tue, 05 Jun 2012 02:36:50 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:79229</guid><dc:creator>WpgAndyS</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/79229.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=141&amp;PostID=79229</wfw:commentRss><description>In the Infopath form, I&amp;#39;m pulling Data from Column1 to a drop down box, I want to populate a text box based on this selection.

I want the corresponding value in Column2 to display howver everytime I try, it&amp;#39;s only pulling the top value in Column2(Green) and not the corresponding one to my drop down selection(Yellow).

Example.

In the Database I have...

Table1

Column1(Primary)	Column2
Apple	                Green
Orange	                Orange
Banana	                Yellow

When I select Banana,  it populates &amp;quot;Green&amp;quot; and not &amp;quot;Yellow&amp;quot;. Any thoughts?

Is this possible? Using Access Database is a requirement.</description></item></channel></rss>