My company uses SharePoint 365 and currently has a document library with several folders and subfolders. The top folders are the names of different customers and the sub folders contain information relevant to each customer. We have over 200 customers so the document library is large. The document library is sync'd with our computers so staff can access from Windows Explorer..
One of the other things we use is a SharePoint list which has other information relating to each customer like Customer Number, Address, Email, Assigned manager etc.
Currently these two aspects are in no way linked to each other which is making managing client data difficult. I'm looking for Someone who is a guru in SharePoint 365 who can provide a solution to better manager our customers information and folders. Maybe a list that can contain the folders within it and still be accessed through explorer or a document library that can somehow contain the other customer data thata is easily accessible an visable. I have created additional columns in the document library but that isnt a suitable solution.
I'm looking for someone who can design and document an implementation plan for me to install as I wont be providing access to the environment given the data is sensitive.