"Hiding" records when revisions are created
Hi, I am trying to create a setting for my documents database where each record contains a document. There will undoubtedly be revisions of some documents as time goes on and my goal is to have all documents, including the originals and revisions, be in the database but I want to have the records with documents that get revised to be "hidden" from all users other than the database admin and only allow the most recent versions be seen and accessed. So whenever a new record is made that is for a revision document I would like the original to be hidden once the revision is uploaded. Help? Thanks!