AutoEnter Images

[Protour Travel]

For Credit Card Authorization forms I have to provide an image of the front and back of the card, the cardholders Drivers License and their signature. I have designed a printable layout for this.

As of now, I have the images stored as Container Fields in a CCInfo table. This table also contains such info as the CC# and other related text files.

My problem is that every time one of my employees sends a CCA, they are having to manually insert the container images from the hard drive onto the layout. I'm afraid that over time the wrong image will be inserted.

I want to AutoEnter the correct images when the DB reads a related name.

The layout I have set up contains only the Body part if this matters. I am using FMP9 but ready to upgrade if need be.

This is probably like most things and a very simple fix but it has driven me batty for the past 3 days.

As always, thanks in advance.

[Matthew F]

If your images are being scanned in an automated fashion such that they are named by serial numbers then you can insert a reference to the image in the container with a 'set field' script step. If you have a global field 'gPath', which is the path to your photo directory then the syntax would be something like:

Set Field ("container" ; "imagewin:" & gPath & serialNumber)

To see correct syntax, insert a photo as a reference in the container and view a calculated field = GetAsText(container).