InfoPath Dev

In the Infopath form, I'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'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 "Green" and not "Yellow". Any thoughts? Is this possible? Using Access Database is a requirement.

This isn't supported out of the box.

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.

Sorry,