Display JPEG via different Mac/Win paths

[mga]

Hi,

I've got a database containing about 400 staff in my organisation. I'd like to have the facility to select a name from a pull-down menu, and have a picture of the person appear (I expect in a container field) on the layout.

The solution must work on Mac and Windows.

An obvious answer is to store the images within the database. But with 400 images of about 10KB each, this makes the db 4MB bigger than it needs to be. I'd like to avoid this if possible.

Storing the images as a reference seems to be the answer, then. But this has the problem that Mac paths won't work on Windows, and vice versa. To get around this, I thought of creating separate Mac and Windows global paths, then combining that with filenames via a calculation to create valid filepaths for each platform. But I then get myself in a bind in that I want the photo to appear automatically, and not via a script. I'm not sure how this would work.

Is there any way to do what I want? I'd rather not use plugins, but I have the Troi file plugin if that helps.

If it can't be done, is the extra 4MB overhead, due to storing JPEGs in FileMaker, likely to cause me a problem?

[Genx]

Theres a get function you can user, i think its Get(SysyemPlatform) or something. Anyway, this will return a result of either 1 for pc and 2 for mac or negative of these numbers, i dont remember, but just play with it. You can then in your picture calc just use If(Get(SystemPlatform) = 1 ; win path ; mac path )

Genx

[mga]

I can't get that to work. The calculation result (which is set to container) gives a text string with the path, rather than displaying the picture.

[Genx]

Are you sure you did it right? Are you sure your using imagewin or imagemac at the start of your filepath?

~Genx