database - LibreOffice Base - Hyperlink Macro -
how 1 create macro hyperlinks data fields corresponding folders on local directory in libryoffice base?
example: client named "jimmy" entered in database. invoice documents located in path "/directory/path/to/jimmy". db admin needs ability click on jimmy's id data field , corresponding folder.
this macro; however, needs update entire database , there hundreds of client records directory structure that's based on db data.
example: client "a" documents in "/person/something/a" client "b" in "/person/something/b"
if skilled , willing assist in writing vb macro accomplishing appreciated.