IMport a movie reference from a field with the movie path

[dkey]

IN my db I have the following fields

IMAGE (CONTAINS 14 FRAMES FROM A MOV FILES AS A JPG FILE)

FILEPATH (TEXT FILE AS FOLLOWS: file://Data/Videos/MVI_9887.MOV)

VIDEO A Container file where I would like to see the "file://Data/Videos/MVI_9887.MOV"

In the DB I have several different records how can I create a SCRIPT AS SUCH

GO TO FIELD VIDEO

OPEN file://Data/Videos/MVI_9887.MOV

I Don't want to keep the video file in the db but only look at it when needed

The various INSERT QUICKTIME, URL and so on require me to set the actual file path for each MOVIE file and this is time consuming as I have more than 1200 records, therefore 1200 movie path to insert

Anu help?

Thanks a lot

Edited April 9, 2017 by dkey

[comment]

If you know the path to a file - either absolute or relative - you can define a calculation field, with the result type being a Container, that points to that file. Then you can open that file by double-clicking the field.

See also:
http://www.filemaker.com/help/15/fmp/en/#page/FMP_Help%2Fcreating-file-paths.html