I have a drop down in SharePoint it needs to contain about 100,000 items from an xml list. This will take too long to load. I want to make multiple small xml files dependent on the drop down above it. example drop down 1 (A-f) will pull a specific a-f.xml (drop down 2) and (g-l).xml and so on. Does anyone know of a way to point to multiple XML lists by specifying which list to pull depending on drop down. Or any better options? Right now at 10,000 items in the list it takes a while to load I'd hate to see what 100,000 items does to the list. Any help is appreciated.