i am looking to make an image show up when select an item type.

I have an image field

and i have a model# field.

I was wondering how i would make a script that would grab an image from a folder named the same as its model number so when you type in the model number the image shows up.

Anyone know how this is done? I would love some help.

Thanks in advance

mattyj

Hi Mattyj,

Your Images should be stored in a FMtable (or separate file)called items f.i containing at least 2 fields

ReferenceID number autoenter incrementing

Image Container

You need to create following additional elements in order to display the referenced Image.

1. Create a new table called Globals with fields

gSelectedRef global number

gEnteredImage Calculation

2.In Database Setup Link Globals->gSelectedRef to item->ReferenceID call the relation Selected

3.Create a new Layout based on Globals TO

Position the gSelectedRef field and the gEnteredImage fields in this Layout

4. Now define gEnteredImage Calculation to be equal to Selected::Image.

Now whenever You enter a referenceID into gSelectedRef the related image will show up

Remark It could be advisable to format the gSelectedRef field as a Popup list showing all available ReferenceID on File avoiding thus the typing errors.

Do not hesitate to contact me if this was unclear or You needed additional help.