I have several Sharepoint sites under a single Site Collection. I want to be able to create a list that can be referenced elsewhere under the site collection.
For example, I have a list of clients that is the same across all sites. When I build, say, a Data View List in a sub-site, I want to have one of the columns be Clients. This could apply for Vendors, State Names, Tax Areas, anything that I might only want to type once.
I have played around with Lookup Columns and saving the original list (e.g., the list of clients) as a template. But not really seeing how to put that information into another list.
What am I missing?
