Hi. I have a database that I would like to add a field to. I want the field to be a link to a PDF file, so that when you click on the link it will open up the PDF in Acrobat. Each record would have a link to a different PDF. I am running FM 5.5 on Mac OS 9. Is this possible, and can anyone help??

Hello,

I can not give you steps in how to do this but,

if you are on a Mac explore using AppleScript. You can make any field a button (a link) that copies a reference and pastes it into an AppleScript file. AppleScript is how you make things work outside of the FMP environment. Good luck.

Steve

This is NOT how to do this using AppleScript. There is no copy and paste. If the value in the field is the full path to the target file, then set a varaible to that field's value and cast to alias. Then tell the Finder to open it. If it is created with a program the yields .pdf (Acrobat, not Microsoft) PDF files, then the finder will oipen it using most lilely Acrobat Reader.

Put this into a ScriptMaker script:

tell application "FileMaker Pro"

set y to get data cell "name" of current record of document 1

end tell

tell application "Finder"

set y to y as alias

open y

end tell

HTH

Old Advance Man