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.