bithurler

The volume would always be local. I'll have a look at it. Thanks for the info! I like this idea, but my concern is, how do I delete the table when I import and perform the find. This would happen over multiple drives so the table would need to be cleared then re-imported with each file list.

So as an example: Then generated filename which is in a field called tempfilestorage would be B148_C003_1119xx.r3d The record of the real file in the text document would be: /Volumes/Bithurler Test Data//Ramville day 15b/B148_11192X/B148_11192X.RDM/B148_C003_1119UN.RDC/B148_C003_1119UN.R3D I would need that file path to be copied into a field in the record with the tempfilestorage. It would be a new field called File Path. Make it a little clearer?

Good Morning, I'm trying to develop a Filemaker solution and have reached a bit of a road block and I'm hoping I can get some help from this great community. Ihave a filemaker database that is taking information on a film set. It records information from the camera. Now that most cameras are digital I need to associate file names to the records that I am creating. Since I can't access the files until after the shoot, also the camera generates random characters to prevent over writing of files I need to do this as a multi-step process. Here is the process I have in mind. The film shoot is broken into days. Each day has a hard drive associated with it. I have an Applescript that searches for only the files that I need and drops them into a Text (txt) document. This is what I need to happen: Using information contained in a calculation field that builds the approximate filename minus the random characters, I need to search the contents of the txt file, find the full file name and insert that into a field in the record. Any thoughts how I get this solved?