InfoPath Dev

Hello, I've created 4 lists in SharePoint 2010. - Country (Country) - City (Country, City) - Location (Country, City, Location) - Information (Title, Location, City, Country) Then, I've developed InfoPath forms for all the lists. In the Location InfoPath form, I've done this using InfoPath functionality of cascading ...

Thanks for your response, ErnestoM Please let me know how can i change the compatibility settings from the designer. Thanks

Hi, I've published a InfoPath form which is using SQL webservice to get the data for the drop downs. The form published fine with no errors. I activated the form from the Central Admin as well. SharePoint uploads the form in the Form Templates. I changed the Advanced Settings to 'Display as a web page'. When i click the form, it ...

kirankanth, i tried it with browser enabled but it doesn't work for me. :( Any other idea ? Thanks

princevis, Yes please, it would be great if you can provide me some code which filters DropDown2 on the selection of DropDown1 value. But, the code access WebService by adding either WebReference or ServiceReference. And, then i can access stored procedures. Thanks in advance

kirankanth, OR simply we can say that it doesn't refresh the DropDown2 if i select another value from DropDown1

kirankanth, Thanks for your quick response. It works fine now. But, there is a small problem. On Preview, when i select DropDown1 Value, it filters DropDown2. But, when i re-select the DropDown1 Value, it shows the ID of the last selected value in the DropDown2 and the filtered values. When i select any of the DropDown2 value, it removes the ID ...

Initially, I'm looking for Non-Browser enabled forms. But, for my further research, i need to know with Browser enabled forms. It would be great if you please let me know for both options one by one. But, the priority is Non-Browser enabled form.

" did you checked Automatically retrive data when form is opend." YES

Kiran, The filter method which you've told me works only when a single table contains values for both drop downs. But, it doesn't work when i pick data for DropDown1 from Table1 and data for DropDown2 from Table2 (Table1ID is also present). Also, Please let me know how can we do this through code ? Thanks