Calculatin Open URL

[Malof]

Hi guys, Im having a problem with an Open URL script to open a PDF file stored on a local network.

I have found a solution but have not been able to perfect it,

you can create a button that does an "open url" the url would be the address where the file is located on the server or computer for example:

M:Filemakerpicsparcelpdfs1049.pdf

I need the file name to change with each record according to parcel number (actual field on the database) M:FilemakerpicsparcelpdfsXXXX.pdf

where XXX= parcel number

so far I have tryed the following

"file://M:Filemakerpicsparcelpdfsmalofdb::parcelnumber.pdf"

but does not open, the only way I have gotten it to work is to open the specific file path but it opens the same PDF for every record.

Please help

[MarkWilson]

""file://M:/Filemakerpics/parcelpdfs/" & malofdb::parcelnumber & ".pdf""

You may need to change the formula slightly to ensure it works on both Macs and PCs.