Wanting to import images, based upon a field's contents/name

[Chris Heric]

Greetings...

I am attempting to build a database, that imports images based upon a relationship of a field name.

For example.. I am trying to take a field name "ImageNumber", and use it to refer to the import of an image named the same (with a .TIF file-extension.)

e.g: User clicks: "Click to import images" and the script might go through each record, determine the value of "ImageNumber" and use it to import a relative file named [imageNumber].TIF into a container filed on that record.

I have tried numerous ways to do this, and I am thinking I am going to have to script it, but I am unfamiliar with the syntax or protocol in which to do this. Has anyone had the similar need, and solved it?

Any assistance would be most welcome!

Thanks!

[Fitch]

You can script it or you can use a calculated path. Something like:

"filemac:/volumeName/directoryName/" & ImageNumber & ".TIF"

[Chris Heric]

Thanks Tom...

I guess I am looking to script this and automate it for all records in the database (Usually about 50-100)

I have tried about 37 times, and keep getting endless loops etc. I am an idiot I know, but, I think I am getting close.

Anyone else ever been able to automate this?

Thanks again Tom.

Chris

[Fitch]

It's possible to use Set Field( image ; path ) where path can be either a field or a variable, and would look like what I described above.

It's also possible to do something like:

Set Variable( $path ; path )

Go to field( image )

Insert Picture( $path )

Note that Insert Picture doesn't work unless the field is active. Also, I believe the first method would always be a reference, whereas the second gives you the option to use a reference or not. (And Set Field doesn't appear to bring in other information such as file size.)

I don't know why you're getting stuck in a loop. That's another issue. Be sure you have the "exit after last" checkbox checked (why isn't that the default!?).