I'm working on a project that has a large number of lists. I'd like to group these lists to make it easier for users to find the list they are looking for.
I'd like a structure like the following:
Site Content \Group A Main List A \Supporting Data Lookup 1 for Main List A Lookup 2 for Main List A \Group B Main List B \Supporting Data Lookup 3 for Main List B \Common Lookup Used By Several Lists
I could make subsites for each group, but it is my understanding that a lookup column can only reference a list in the same site. I would be able to access data in the current or the parent site, but not sibling or child sites.
This will make my structure look like the following:
Root Site Lookup Used By Several Lists \Subsite A Main List A Lookup 1 for Main List A Lookup 2 for Main List A \Subsite B Main List B Lookup 3 for Main List B
While this will reduce the number of lists a user is sees at any point in time, it does not provide a clear indicator as to which list is the "Main List" for this group.
I've created new folders in SharePoint Designer, and moved my lists into these folders, but the only thing this appears to effect is the URL.