Linking to and opening external files

[gardenlevel]

I have been reading some similar posts, but can't seem to get this to work.

I have a db where each record is tied to (by using the same name) an external ods (Open Document Spreadsheet) file. I want to be able to click a link and open that file from the server. The files can be accessed by everyone in our office by visiting 192.168.1.80OfficeWorkOrdersWO-XX-X.ods

Is there a way to create this link automatically? I know that container fields can hold references, but I would rather have a simple button link to the file from the time my record is created.