https://www.infopathdev.com:443/search/SearchResults.aspx?q=cascading+dropdownsSearch results for 'cascading dropdowns'en-USCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/p/40321/124700.aspx#124700Tue, 01 Feb 2022 17:41:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124700lou dHello, Not sure if this is cascading dropdowns, or if I need to create an XML data source, but I have two dropdowns, i.e, Dropdown A and Dropdown B. Dropdown B has only two values in the list - Material and Non-Material. If the user selects a certain value in Dropdown A, I want to force Dropdown B to default to a value of Material. If the user selects any other value, i want to provide the user with the ability to select either Material or Non-Material (i.e, just leave the second dropdown alone). I don't know if I need to use XML data source, or if there is a simple way to do this with rules. Thank you for any assistance. Louhttps://www.infopathdev.com:443/forums/p/40241/124348.aspx#124348Thu, 12 Aug 2021 05:54:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124348markikavHi InfoPathdev community! Hopefully someone has had similar use case to this and point me in the right direction. I have a service request process with the data stored in a sharepoint list and data entered via Infopath form on the sharepoint site (they have infopath 2013). The service request "case" can have multiple requests in it based on Service Line and Scenario, we allow them to enter 6 requests. Example Request 1 Service Line 1 = Transaction Queries Scenario 1 = One Payment - Additional Info Request 2 Service Line 2 = Transaction Queries Scenario 2 = One Payment - No Additional Info Request 3 Service Line 3 = Payments on Hold Scenario 3 = Email to Customer Request 4 Service Line 4 = Direct Debits Scenario 4 = Cancellation Request There are 25 Service Lines all with 5-10 Scenarios which I have configured using a sharepoint data connection with cascading dropdowns and works nicely (thanks to this forum!) Last part of this is that they want the ability to QA how the request was dealt with by an offshore team, so per service line they have defined multiple error scenarios that they want to rectify, these are multi select. So what I want to do is in a QA view in the form present them with one instance of the Service Lines errors multi select fields based on the Service Lines selected in the main requests. Example as per above , there was 4 requests but only 3 Service Lines, so I want to present the Error fields multi select boxes now for the 3 Service Lines.. E.G Service Line = Transaction Queries Errors = Incorrect Template , Incorrect info provided, No Follow Up and all 3 could apply or just 1 or 2 etc i.e. multi choice select and this would cover the 2 requests made There is probably a crude way to do it which I'm trying to avoid as I will need multiple extra fields with tons of sections to hide I would imagine! Any help here on a good approach appreciated. Thanks Mark https://www.infopathdev.com:443/forums/p/40036/123571.aspx#123571Thu, 15 Oct 2020 14:49:27 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123571gregglw5Trying to get my cascading dropdowns to function properly and I'm having the toughest time. I created 3 list and I'm trying to link them together and I'm having no luck. I feel either my lists aren't setup right or my data connection is wrong. Could someone assist me with this?https://www.infopathdev.com:443/forums/p/40011/123528.aspx#123528Tue, 06 Oct 2020 15:29:16 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123528ipisorsSo I am trying to do something to a SP list, after linking it inside an Access database, and I am coming across this problem whereby I am able to 1) add records in Access, 2) edit records in Access--UNLESS I go to SP online and populate the People fields in between 1 and 2. The second that I add People information (online, since I can't seem to do it in Access, even when I use the People integer value).......as soon as I've added People information online, then if I try to edit any record in Access, I get ""You cannot update this field because the value you're trying to apply is not valid or would break a data integrity rule. Please correct and try again." Researching this, it seems that Referential Integrity ONLY comes into play if you have actually created a Lookup-type column on your List Settings in the first place (which we have not). But my question is, I know that the person who created this list tends more to create cascading dropdowns (and maybe lookup-type functionalities?) inside Infopath, rather than using a Lookup column in the List Settings online. So....would it be possible that they've created, using the Infopath form design, some type of lookup dependency which is causing it to behave like Referential Integrity is set? Which might be leading to this error in some way? Is that even possible...https://www.infopathdev.com:443/forums/p/39968/123322.aspx#123322Thu, 13 Aug 2020 17:42:15 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123322heath3106Thankfully, I was able to figure it out. Your solution put me on the right direction. Thanks.https://www.infopathdev.com:443/forums/p/39968/123321.aspx#123321Thu, 13 Aug 2020 12:42:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123321heath3106The filter is set up and the dropdown shows a set of rows, but they are all blank, no values. https://www.infopathdev.com:443/forums/p/39968/123320.aspx#123320Wed, 12 Aug 2020 19:44:24 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123320heath3106So I think I have the filters set up correctly. However, dropdown 2 is not showing a list of values to choose from when I select the field. https://www.infopathdev.com:443/forums/p/39968/123319.aspx#123319Wed, 12 Aug 2020 18:35:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123319Hilary StoupaIt may be a little more complex than that - in the condition builder for the filter on drop down b, you'd select the abbreviation from B. Then is equal to and in the third dropdown, use a formula. In the formula, you'd pick the abbreviation from data source A and add a filter - in that filter, you'd select the region in data source A is equal to the selected region in the form. Hope that makes sense. :)https://www.infopathdev.com:443/forums/p/39968/123317.aspx#123317Wed, 12 Aug 2020 15:35:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123317heath3106Does this look right for the filter? abbrev (a) is equal to abbrev b and Region (a) is equal to Region (form) https://www.infopathdev.com:443/forums/p/39968/123316.aspx#123316Wed, 12 Aug 2020 15:22:08 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123316Hilary StoupaDoes the data source for A contain the abbreviation? If so, this can be done, but the filter is a little more complex. When you add the filter to drop down B, you'll add a filter where the region abbreviation is equal to the region abbreviation in the data source for A where the full region name is equal to the region selected in the form. It sounds a lot more awful than it actually is - attach a copy of your form under the options tab in a reply if you'd like a hand. :)