Hi,

Could some tell me if this is even possible or tell me of a better way of doing it.

Our officers go out and take (lets say) 20 digital photographs, they return to the office and start entering their information into the database. Is there a way to either attach that folder of photos to a specific record?

Or

what I would really like to do is import all the photos at once(not a reference but the actual photo as space is not a problem, and the volume of photos will never really get to be too large) to a layout containing containers so they could add notes as well.

If an import can be done, is there a way to make it a simple operation so they dont mess it up.

Can this be done?

Thanks,

James

Edited January 5, 200818 yr by Guest

Well, there's Import Folder, with the option Pictures. To "attach that folder of photos to a specific record", you would import the images into another table, then Replace the ID of the parent record into the records with the images.

There are options to bring in the FileName, the FilePath, and to create a 128 Thumbnail. Probably the FilePath is not much use if you're going to embed the images.

If you're going to do a lot of these, you might consider putting them into a separate file. It just makes things easier, say for backups. But if they are fairly small jpegs then I wouldn't worry too much.

Thanks,

Could I bother you for one more bit of info?

How do I replace the ID of the photos withe the ID of the parent record?

Is this a scripted step or somenting that is done during the import?

This is my first attempt at doing this, and nothing is covered in either of my books.

Thanks,

James

Edited January 5, 200818 yr by Guest

"Replace Field Contents" is the actual name of the FileMaker command. Look it up in FileMaker Help. It is very powerful, especially using (•) Replace with calculated result.

Here is a little example file, a modification of one I had that extracts the folder name. You can ignore that.

Import_Pictures_wReplace.zip

Fenton,

Thanks a bunch, that is almost dead on the money at to what I was trying to accomplish, of course mine turned out to be a pile of mush.

Here is a question…how the heck or where the heck does one go to learn something like this. None of my books have anything that would have lead me in this direction.

Again, thanks for your time, I am tearing into the example trying to learn what you have provided.

Again, much thanks

James