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
1) Apple-Green
2) Orange-Orange
3) Banana-Yellow

When I select Banana,  it populates "Green" and not "Yellow". Any thoughts?

Is this possible? Using Access Database is a requirement.