Newbie Questions

Re: Third cascading drop down list - from sql table

maxmum — Mon, 17 Sep 2018 18:01:25 GMT

Thank you I will try that tomorrow!

Re: Third cascading drop down list - from sql table

Hilary Stoupa — Mon, 17 Sep 2018 14:46:01 GMT

Your filters look right. The issue is how you've configured your dropdowns, I think. Right now, you have the value and display set so that the Service dropdown will store a Network value, and the Team dropdown will store a Service value. That is why your filter on Team isn't working - the value stored in Service is going to be a Network, so the comparison to Service on Team will not be correct. I've changed that in the attached copy of your template. Right click the linked file, save it locally. Right click the locally saved XSN and select Design to open the form in Design mode. Then you can preview it and give it a try.

Re: Third cascading drop down list - from sql table

maxmum — Mon, 17 Sep 2018 09:29:51 GMT

Fantastic thank you for the instructions. I think I have attached it now.

Re: Third cascading drop down list - from sql table

Hilary Stoupa — Fri, 14 Sep 2018 15:09:14 GMT

When you click Reply there should be an options tab - see screenshot. If you change the first dropdown in each of your conditions to "the expression" the full XPath will display. Can you paste that into a reply?

Re: Third cascading drop down list - from sql table

maxmum — Fri, 14 Sep 2018 09:15:53 GMT

It won't let me attach or post a picture, it is 'exisiting filters:

network = Network and service = service

Re: Third cascading drop down list - from sql table

maxmum — Fri, 14 Sep 2018 09:14:15 GMT

Hi I can't find an options tab on here or anywhere to upload a file. Can you see this screenshot? So sorry I am a newbie.

Re: Third cascading drop down list - from sql table

Hilary Stoupa — Tue, 11 Sep 2018 14:51:30 GMT

Well - there isn't any restriction on the number of cascading dropdowns, so I'd suspect the issue is with the filter you have on your third dropdown. Can you attach a copy of your form under the Options tab in a reply so I can see what you've got for a filter?

Re: Third cascading drop down list - from sql table

maxmum — Tue, 11 Sep 2018 06:02:22 GMT

Hi,

Bump for any help please? Have I posted in the wrong place or is this just not achievable on InfoPath?

Thanks in advance

Third cascading drop down list - from sql table

maxmum — Mon, 10 Sep 2018 09:03:28 GMT

Hello,

I have successfully set up a sql connection to a table that has three columns, column one feeds through into an InfoPath drop down list - fine no problem, the second column which is dependant on what is selected in the first column also feeds through fine (filtered). I cannot however get the third list, which is also to be a cascading list (as I understand they are called) to work. I have followed the same procedure as I did with the second cascading list but nothing appeared in the third list at all/

For example in the sql table I have three columns: Network, Service and Team.

Select a certain network in list one, you get the appropriate services in list 2 to choose from, but then that should also apply to list three - it should filter the results to return all teams with a certain Network and service selected.

Thanks in advance for any info to help me figure it out!

Rebecca