The alternative is to give direct paths to the BIB files. However, that is an issue when you collaborate with people on a document.
Furthermore, it seems there is a bug in LyX. When I give direct paths to the BIB files, the citation dialog box becomes superwide, stretching beyond the width of my large screen. How can I solve that?