https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/122116.aspxThu, 05 Dec 2019 17:59:24 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122116Ruenells0https://www.infopathdev.com:443/forums/thread/122116.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=122116Yes I am working on that next. Just finally figured out how to do an XML file yeah me!! Thanks again Dorindahttps://www.infopathdev.com:443/forums/thread/122115.aspxThu, 05 Dec 2019 17:50:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122115Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122115.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=122115This is not a good plan, I'm afraid. I think a 29,000 row XML file will make your form very large, and that a dropdown with 29,000 options would be unwieldy for users. I think instead you need to consider ways you might structure this data in a SharePoint list that would allow you to offer some filtering. Not knowing what this data is, I can only suggest some guesses - but perhaps you could categorize these entries, and give the user a "Category" dropdown first, with limited options, then filter the query for the "Very Large List" data based on the selected Category. Even if you stuck a column in SharePoint for the first letter of the option and let the user initially select from A - Z to narrow down the data returned to the dropdown, it would help.https://www.infopathdev.com:443/forums/thread/122112.aspxThu, 05 Dec 2019 16:12:57 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122112Ruenells0https://www.infopathdev.com:443/forums/thread/122112.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=122112I have a large list that I need to create an XML from so that I can use it in a dropdown in my form. I do not know how to do this and hoping someone can point me in the right direction. Dorinda