InfoPath Dev

In my form I have a table with 4 columns, the column headers are: Code, Item, Unit, Cap.  I have a SharePoint list which contains all the data with the same 4 columns.  I would like to be able to have the Code field as a drop down list in my form that looks up all Codes in the SharePoint list and once I choose a code, the other 3 fields get automatically populated with the appropriate data for that code. 

I have the drop down list working, it finds all the data from the SharePoint list, I just can't make it populate the other 3 fields.  How do I do that?

Hi jambou9182, for that you can configure the default value, click on properties, "Fx", insert field or group and select your secondary dataconnection and set a filter with your drop down and the code value of your data connection.

Thanks for your reply.

So I was able to get the three columns to change based on what I choose from the first column drop down list, however, if I change the drop down list to something else the other 3 columns don't change ,they don't do anything.  How do I make it update the other columns again?