InfoPath Dev

Hi, I have searched the net and I did not find any approach related to the approach im thinking. And since I'm here, I would like to know if this is possible:

Scenario is: A user will choose a value from the dropdown, for example, I have these controls drpDown and txtBox.

What I want to do is that I will be creating a list and will be the data source for the dropdown. the list will contain 2 columns: Column1 and Column2

Contents are:

Column1    Column2

Paper         Pencil

Board         Chalk

Notebook    Ballpen

So if the user will choose "Paper" in the drpDown, txtBox will be populated with "Pencil", or if Board is chosen, Chalk will appear in the txtBox

My question is: is this possible? any tutorials or step by step? im new to infopath so please bear with me thanks!

I've attached a sample that leverages a data connection to an XML file included as resource to the form to do this. Right click the link in the header to the post and "Save As" to save locally. Right click the local copy of the file and select Design to open in design mode. There is a rule on the drop down that sets the value of the text box.

Hello:

I am trying to develope a form with a populated repeating table from a sharepoint list that has duplicate values in two of five fields.

I need to have a dropdown list with independent dropdowns for each row in the repeating table either in the table itself or somewhere else.

Then I need to save this data to a list for use in other forms or in another section of this form.

 Sharepoint list data source

Any help would be appreciated..