Exactly the same problem here. I tried different ways to get this to work, but everything seemed to just add too much friction. Links tend to break and become useless very quickly.
The simplest solution is often the best, so what I do now is to drop the files that contain critically important information into Obsidian. Anything else, and especially working files go into a project folder with the same name as the project note. All my project folders are in a single/known location.
In most cases I know what I’m looking for and go straight to the right place. If in doubt I start to look for the info in Obsidian, then go into the project folder and voila …
My work must happen on a corporate issue Dell laptop with Windows, however I’m able to sync my vault to my iPad and iPhone. With my approach I manage to keep my vault relatively lean, but I can quickly look up anything from anywhere and add some thoughts whenever inspiration strikes.