Is there a way to pass along a filename from a field to a script for import? I want to automate the script process (which I've done) but I still have to tell the script which filename(this changes daily)and directory to find the import file. I wanted to pass these values from the data in the database (they exist).

Not that I'm aware of. I've often wished there was!!

Would it be possible to look at it the other way round and export the data from the other file? That way you could run a script from the main file and use Send Message specifying a filed for the file name. You could set the script in the secondary file for exporting data to run automatically on start up.

If you are using a Mac, then you can use Applescript to do this. If Windows, have a look at this topic:

http://www.fmforums.com/ubb/Forum26/HTML/001236.html

Thanks for the answers! I can set the other program to export to a single filename each time (its using the system date to build the filename now). Or perhaps I can write a little fmp program to take the employees punches for the day....yes I'm sure I can.

Thanks again!