SharePoint Integration

Re: Help? - Auto-Populating a table from SharePoint 2007 list

jambou9182 — Mon, 25 Oct 2010 17:33:11 GMT

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?

Re: Help? - Auto-Populating a table from SharePoint 2007 list

Potemkine — Thu, 21 Oct 2010 20:05:35 GMT

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.

Help? - Auto-Populating a table from SharePoint 2007 list

jambou9182 — Thu, 21 Oct 2010 19:41:49 GMT

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?