I store projects on a server and have made it so that the database links directly to Fee Proposals within the project folders.
Once a project is complete, it is moved to a different place on the same server and this is shown on the database with a tick box.
Could it be possible that upon ticking this box, the hyperlink changes itself? The only thing I'd need to change would be the drive letter and the rest of the path would be the same.
Furthermore, we currently have two offices with two servers. So 2 drives with live projects and 2 with closed. If the above is doable, could I then add a variation, so if it's on drive A: it automatically becomes B: wheras C: always becomes D:?