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!

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

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

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

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!?).