Linking Filemaker records to files on a hard disk
Posted on 2004-04-04
I have a FM database that has info on thousands of sound files. There is even a container field where I can import an mp3 so I can hear the sound.
Now that I have a hard disk big enough to hold all these files, is there a way to link all the soundfiles with their proper filemaker records so I can hear them from within FM? The filename field in FM always is the same as the file name on the hard disk, except for the suffix (.mp3, .aif, .sd2 - etc.)
The alternative seems to be to go to a record, click import, search for the file and click OK - thousands of times!
It would be nice, but not essential to be awarded points, if the solution allowed for relatively easy updating - as when new files are added, or when files for some reason are moved.