Playing video or audio files from container fields
I am attempting to do something which on the surface seems simple, but has me stumped. I have a database that I created in FM9 which contains information about video and audio files that I have in my archives. I would like to put a link to the file in each record, and I have been been able to sort-of do that with a container field, but I'll be darned if I can figure out how to PLAY the media from there.
In the container field, I select "Insert File," then select the file and check the "store reference only," as I don't need the file inside the database. I then get an icon for the file, and the filename -- but I can't DO anything with it. Silly me, I thought if I just double-clicked it, it would open the associated application and play it.
Am I making sense? Is there a way to do this? Any tips appreciated!