I implemented cascading dropdown for City, State and Zip for a site collection. We are housing over 60 site collections and most of the now going through business process development. There is a huge demand for infopath forms with cascade drop down.
Does this mean all of those 60 site collections needs their own list for City, State and zip and maintain their own? This sound cumbersome to me.
Are there better solution as to maintain one set of lists (City, State and Zip) and consume it from one location?