https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/122155.aspxTue, 10 Dec 2019 18:59:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122155Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122155.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122155Send me your file (with the XML as a resource) using this link: https://www.hightail.com/u/QdabraSoftware466460 and I'll take a look.https://www.infopathdev.com:443/forums/thread/122154.aspxTue, 10 Dec 2019 18:16:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122154Ruenells0https://www.infopathdev.com:443/forums/thread/122154.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122154Yes and there is no N/A in it at all. As far as the repeating group, the above cascade dropdown filter down the items in the repeating table below. So I need a way to have the selection of the first group and if it is not empty or if they change category to not clear or hide something that is already filled out, but continue to filter down the line to the individual line items.https://www.infopathdev.com:443/forums/thread/122153.aspxTue, 10 Dec 2019 17:50:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122153Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122153.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122153Without seeing the form with the XML resource file I can't begin to guess. Have you opened the XML in a text editor and searched for "#N/A"? I think in another post, you talked about creating this XML from Excel - #N/A is a common error in Excel, like when a VLOOKUP doesn't return a value. In the last version of the form I looked at, your cascading dropdowns weren't in a repeating group. Has that changed?https://www.infopathdev.com:443/forums/thread/122152.aspxTue, 10 Dec 2019 17:18:56 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122152Ruenells0https://www.infopathdev.com:443/forums/thread/122152.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122152I dont understand how to tell it to not include something that is not in the XML. The file doesnt have any #N/A in it...however that is showing up in every dropdown regardless of the xml attached.https://www.infopathdev.com:443/forums/thread/122151.aspxTue, 10 Dec 2019 17:16:06 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122151Ruenells0https://www.infopathdev.com:443/forums/thread/122151.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122151so i am concerned that on this form they may be selecting different group and sub group i do not want the selection that they have chosen to go away from the first entry and subsequent entries how do i put a rule that will allow them to keep entering in the repeating table and allow them to select different subgroups?https://www.infopathdev.com:443/forums/thread/122150.aspxTue, 10 Dec 2019 17:06:45 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122150Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122150.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122150If there are specific values you don't want to display that your original filter doesn't exclude, you have to add to the filter.https://www.infopathdev.com:443/forums/thread/122149.aspxTue, 10 Dec 2019 16:51:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122149Ruenells0https://www.infopathdev.com:443/forums/thread/122149.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122149so here is a new twist even though I have an xml pointing to a dropdown it is pulling in a category that equals N/A i dont want that...do i have to make a rule not to include them?https://www.infopathdev.com:443/forums/thread/122148.aspxTue, 10 Dec 2019 15:45:31 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122148Ruenells0https://www.infopathdev.com:443/forums/thread/122148.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122148ok so all of my xml need to be attached I did that and it is all working, the only issue is the repeating piece from before.......just wish i knew how to make that go awayhttps://www.infopathdev.com:443/forums/thread/122147.aspxTue, 10 Dec 2019 15:35:12 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122147Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122147.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122147InfoPath is going to use XPath notation - the period is normal. https://www.w3schools.com/xml/xpath_syntax.asp for more. I don't understand this: "If I have it pointing to the sharepoint library it will not pull the data" - I don't know what that means. If your data connection is setup to use a resource file from the form, the resource file must be present in the form for there to be data. As I mentioned before, I only had you remove those so you could attach the form template to your post, because the extremely large XML files are making your form very large too.https://www.infopathdev.com:443/forums/thread/122146.aspxTue, 10 Dec 2019 14:27:29 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122146Ruenells0https://www.infopathdev.com:443/forums/thread/122146.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122146The other thing that is weird is that I cannot use the cascading dropdowns if the resource file is not attached to the form. If i have it pointing to the sharepoint library it will not pull the data. Is that normal?https://www.infopathdev.com:443/forums/thread/122145.aspxTue, 10 Dec 2019 12:23:59 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122145Ruenells0https://www.infopathdev.com:443/forums/thread/122145.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122145I cant figure out how to get this to work without the periodhttps://www.infopathdev.com:443/forums/thread/122142.aspxMon, 09 Dec 2019 20:32:50 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122142Ruenells0https://www.infopathdev.com:443/forums/thread/122142.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122142So I discovered something very weird and I dont know how to explain it. I had gone back to my rules to clear the cascading history and saw that in the sub group i had this . Just a period, when I removed it nothing would populate the dropdown. If I put it back i got the previous selection but all of the rest of the selections. I have no idea how i put a period in that ......but why would that work and not the filter i have in place?? Here is the form with the period in the BG field filterhttps://www.infopathdev.com:443/forums/thread/122141.aspxMon, 09 Dec 2019 20:07:58 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122141Ruenells0https://www.infopathdev.com:443/forums/thread/122141.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122141OK I changed out the top dropdown for option buttons and the first dropdown works but the second one isnt can you take a look please. the details are not filling in on the Additional Details dropdown. Dorindahttps://www.infopathdev.com:443/forums/thread/122139.aspxMon, 09 Dec 2019 18:33:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122139Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122139.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122139The only thing I can guess is that it is because the first item is a multi-select. I've sometimes had issues with rules on those - they don't seem to fire as consistently as rules on other types of controls.https://www.infopathdev.com:443/forums/thread/122137.aspxMon, 09 Dec 2019 18:26:51 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122137Ruenells0https://www.infopathdev.com:443/forums/thread/122137.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122137here you go