It is a question I ask several time and the answers are not clear to me. Maybe I am not fast enought. I should go to VB... ;-)

I have several situations in my developments where I need the user to be able to add an image to a record. For example, in a client file, to add the client logo; or, in a golf club, to add the map of the field.

I wonder how I should handle this. From my previous postings, here are the various answers I got:

1) Just put the image file in a directory and keep the address in the record. Retrieve it in an image object.
Ok, it seems simple enought. However, I don't like the idea of having the user playing around with the image directory with all the dangers like deleting a file per mistake and so on.

2) Use a memo field to store the image. USe FILETOSTR to copy it in the memo.
Ok, but how do I actually show the image ? Do I put the image in a temporary file and show it using the image object? Then I have to make sure I delete this temporary file when it is not needed any more.

3) USe a general field to store the image.
Ok, this one seems to me the logical answer. But, then, how do I let the user pick an image and store it in the field (from a screen, not from the general field popup-when-you-double-click-on-it ?

Thank you
Eric