I'm looking for a way to categorize and tag a large number of documents that will be part of a research project in Geophysics. There a few types of records, such as logs, rock testing and core analysis.
The metadata associated with each type of document is very different, but have a few items in common, such as "on/offshore" (choice menu), location (single line text) and lithology (choice menu).
Would it be possible for me to create separate folders with different classes of documents (and thus different metadata) and have each of the documents' first few columns (items in common) automatically transferred to a global folder displaying all of the documents? Granting access to different people would be nice, but not essential.
Would I be better off using access or Nuxeo instead?