I use the following approach: (1) There is a main folder for images that is specified as a property of my application object. (2) Because I read somewhere that more than 1,024 subfolders slows Windows down, I use a naming convention for subfolders beneath the main images folder -- e.g., ImagesNNN, where NNN is between 000 and 999 (created as needed). When saving a particular image, I determine its subfolder -- i.e., NNN -- based on a function of the primary key of the record to which the image pertains. (3) For the name of the image file itself, I also use a naming convention based on the primary key of the record and (if necessary -- e.g., in the case of multiple images per record) the name of the control that is used to display the image.

With this naming-convention approach, I do not need to waste space storing any image information at all in the record itself.

-m.

**************************

>Hi,
>
>in addition to Tore's and Naomi's answers...
>
>Not only should you save a 'path/filename' reference in a field of the table. You should also take care, that the user only selects the image from somewhere in his network and then your prog should store the file in a centralized directory, so that all users can access it, when viewing the record. This directory should have subdirectories, according to your index field(s) in your table. That way you won't end up with thousands of files in one directory only. An additional option could be, to rename the file to a sys(2015) (and/or index tags) name. Your table would keep the original filename and the constructed one. This takes care of potentially identical filenames.
>
>
>>What is the best way to manage and display images associated with records in a table?
>>
>>I have a form that displays individual records from a table where each record represents an employee. I would like to add a new field to the table that contains a picture of the employee and display that picture on the form. I would also like to give the user a convenient way to browse to a picture and update the field with the employees picture.
>>
>>Can anyone point me in the right direction?