Regarding value list and file path

[laday]

Hello All! I'm totally new to FMPro. Having a bundle of fun and very pleased with myself until I tried to define a value list with images in a folder on my hard drive. I'm trying to get a container field to offer a choice of 5 jpeg images. I have tried every variation under the sun with that file path and get "...snytax/can't find file..." error message every time! Arrggghh!

Thanks for your assistance!

Lisa

[laday]

Whoops! Sorry about that...I see I posted this message in the wrong forum. Should I repost it in values list forum?

Lisa

[Fenton]

This is the right forum. But it's kind of hard to tell what you're trying to do. We need a longer, more detailed dispassionate explanation. For one think, it is not possible to show an image in a "value list." But it is possible to show 5 images that match some conditions, in a portal, where you could then click on one to make a selection, then do something with it (view it? in FileMaker? open it?).

It is also possible, in FileMaker 7, to construct a calculation using a file path which will then show the image from an image file. Obviously you have to know at least the relative path to the image, from the database; or its absolute path.

[laday]

I see...I was way off base in what I was trying to do...in both design and accomplishment. Found a section on tables and relationships and figured I could do it by creating one table for images and another for Action Items and then establish a relationship between the two. Works neat!

OK for that part, it's a 1:1 relationship between action item and picture, but am I to use that same method and create a relationship between locations and map (graphic), where one of 4 maps is associated with each of 14 locations?

Thanks very much for your assistance.