I work at a smaller company. We are currently using Dropbox to manage project folders. One person will create drawings and place them in a folder. Another will check them, sign on the PDF of the drawing, and place into a different folder. Another user will do the same, until there's a final resting place for them, a completed folder we have.
Problem is that if you are trying to look for a specific project, you might have to click through a few different folders until you find what you are looking for. And, some of the users are pretty bad at cutting and pasting one folder to a different location.
I was trying to see if there was some way of having a database that lists where folders are located, maybe evening having a hyperlink to them, e.g. I look for project X in this database, and am able to get pointed to its spot in Dropbox.
If a user checks a drawing, maybe they could also press a button (via macro, something) in the database that would automatically move the folder to the next location to be checked and update the hyperlink.