I have a database with 1200 students each student has a unique ID Number i.e. Joe Bloggs would be 9079.

I have taken a photograph of Joe Bloggs on my Digital Camera and have saved the image as their ID number 9079.jpg. Is there a way that I can get every students picture to be inserted automatically using the Pin number as the link i.e. the field uses the ID number to look for the relevant picture file.

If this is on a Mac, I would use AppleScript. If it's on a Windows machine, WinBatch might do the trick.

Chuck

Cheers Chuck

What is WinBatch?? I have unfortunately never heard of it and my IT Dept have gone home.

Check out http://www.winbatch.com/

I haven't used it myself, but have heard that WinBatch can duplicate much, if not all, of the functionality of AppleScript. So, for instance, with AppleScript I would write an applet that goes through a folder's items, takes not of the name of each item in turn, and looks in FileMaker for a record with that item's name (minus the .jpg extension). If it finds the record, AppleScript would tell FileMaker to import the file. They tell me this kind of thing can be done with WinBatch.

Chuck