I have a situation where I have a database managing house inspection
data. I would like to customize the report that I print out for the
customers with an image of their home on the first page of the
inspection report to customize it a bit, as well as an additional area
at the end of each personalized report with 4 pictures of their home.
Would there be a way to setup the database so you could click on an
image area on the first page of the report where Filemaker would open a
window requesting me to choose the image to insert and save it to that
record? I realize I could go into the layout and manual insert each
time, but would like to make it simpler and more automated. Has anyone
done anything like this? Also, would it cause issues with the database
to store the additional images in each record? Would the database
become too large/ bloated? (I plan for the images to be fairly small)
If this isn't possible with Fiemaker alone, does anyone know of a
plugin to accomplish this?

I am using Filemaker 7 on Mac and PC platforms.

Any input or help would b greatly appreciated.

TIA,
Stephanie

Stephanie,

You can do all of this, but you need applescript or a plug-in like troy
file-plugin to grab the path and filename. Is there a reason you want the
pcture in the file. You could also use one folder to store all pictures,
then naming the pictures according to the id of the roecord. Then you create
a calculated container to store a reference. Thus the picture is visible as
soon as you have stored it in the folder.

Storing inside a table (V7 and up) would not bloat.
You can define a container as a button that fires a script.
in this script you build an applescript (which I have done before but can
not retrieve right now)

Both have pro's and cons, I have made the choise to use reference,
calculated containers.

Ursus

<sgesler (AT) gmail (DOT) com> schreef in bericht
news:1164053547.936215.20710 (AT) h48g2000cwc (DOT) googlegroups.com...

sgesler (AT) gmail (DOT) com wrote:

I have implemented several image storage solutions. I import all images
into the db, the trick, as such, is to name the parent folders
(directories), so that it can be correlated to the property/patient/...
record. The filename and path can be parsed at import, and the parent
parsed from the path.

Once the images are in the db, and attached to the house record, it is
straightforward. You will need images with 300 dpi for printing.


Chris Brown