Say, I have 20 sub-sites under corporate sales. There are 3 lists that drives the look up columns.
Country (USA, Mexico, Norway, Morocco, etc.) Regions (SW, NW, S, W, N, MW, etc) SalesArea (Service; New Sales; SOA)
The Regions and SalesArea constantly gets updated by the legal and sale team. I don't want to maintain these list at sub site level.
Can the site collection host this list so all the sub-site can consume these list for look-up columns?
I know I can create "Site Columns" with lookup type and that way sub-site can consume the Site Column. But I am using spService for cascade dropdown and it needs the list name. Will the spservice jquery cascade dropdown work if the list is not present in the sub-site level?
What would you do? I would truly appreciate your feedback and suggestion.
I thought about creating lists at the site collection and external list at the sub-site level. But then I have to create 60 external list (3 external list per sub-site to consume list from it's parent)