Data Connections

Re: Using different SP lists based on user drop-down selection

saswiss — Thu, 17 Nov 2011 09:44:56 GMT

Hi Ernesto,

thanks! worked like a charm :-)

take care

Re: Using different SP lists based on user drop-down selection

ErnestoM — Mon, 14 Nov 2011 15:37:16 GMT

The simplest way to tackle this problem, I think, is to have multiple dropdowns in your form. They are all hidden when the form loads. When the user selects a value for Country, then you can call the SharePoint list data connection for that country and show the content in the form. Does that sound reasonable?

Using different SP lists based on user drop-down selection

saswiss — Mon, 14 Nov 2011 14:12:08 GMT

Hi,

I have an InfoPath 2007 form where the user has to select a country and then based on this selection the same drop-down field appears, but the data source (for the content) is different - based on the country.

For instance:

Country= Germany, SP List=Germany

Country=UK, SP List=UK

once country is selected, the next drop-down uses the specified SP list.

Hope this makes sense...Any suggestions would be greatly appreciated!

Thanks