Relating an image to a primary key

[bells_theorem]

To make my database user friendly, I would like to have the user click a field that then displays a related image, instead of forcing the user to drag, drop, and re-size the image to fit the field.

For example, say I have a directory on my server that stores employee images. I then want a button (script) in my Filemaker layout that will insert and re-size a JPEG image ("employee picture 001, 002...") that is directly related to the primary key ("Employee ID 001,002..."). I have had trouble with this since it seems that you can't relate container fields (The container field cannot be selected in the relationships window). Now I'm thinking a container field isn't the way to go?

It seems like this would be a pretty standard function for Filemaker, since many databases store field-related images. I've tried to write a script using the "insert Picture" function, however, the picture shares no relationships. Any suggestions?

[iMarcW]

When you import a folder of images, FileMaker gives you the option of importing the file name (and path) along with the image. If you imported your images (or a reference to the image) into a separate table, the file name could be the key that links the image to the employee record.

[bells_theorem]

Worked great. Thanks for the help.