Adding a field contents to a pathname

[thegaijin]

I'm kind of a beginner with FMP and a real newbie with Applescript.

I've created a DVD library (based intially on the Film Library Template) and now have some 300 titles added. I'm now adding the VIDEO_TS data to my hard disk and would like to play them from FMP. I've added a play button to one of my layouts to call an applescrpt to enable me to play the currently displayed DVD title.

The location for the DVD data is as follows;

HD:Users:Me:Movies:Library:X:VIDEO_TS

Where X represents the "FilmID" cell of the current record.

How do I build a pathname in Applescript that will get the value of X from the cell "FilmID" from the current record?

I've managed successfully to play a DVD when adding an absolute path but have no idea about the commands and syntax to take it to the next level.

Any help and advice most welcome.

Cheers,

Andy