Filemaker help

I want to create an event (button click) in Filemaker 7 that when activated goes out to a finder browser box at a specific location (specific folder) that when a file is double clicked will return the path name to a specific field within the database. It seems simple enough, but I don’t have the faintest idea of where to start. I am new to this.

you can use this code as applescript aplication and make a script in failemaker that perform an apple event
just replace the “FieldName” by the name of the field in your FileMaker DB


global pathfile

set pathfile to choose file without invisibles

tell application "FileMaker Pro"
	set cell "FieldName" of current record to pathfile
	
end tell