Well, first, you have to decise on how to store the references to the pictures. Maybe just a character field with the pointers to the pictures. Since there can be more than one picture, I would use some character to delimit the pointers. Then when you want to show the list of pictures (building a listbox), you can use the AT() and SUBSTR() functions to build the list as you would like. I would do something like this when storing the list of files: ...

So, use a delimiter to split the filename from the description of the file (to be used in the picklist) and use another delimiter to split the next picture.

When the user picks the file they want, display it in your chosen control.




>Ok, I will do this little over again (and hopefully shorter).
>
>How would you handle JPEG image without having the image IN the database/table?
>
>Lets say I have inventory system created by VFP 6.0.
>The unique ID field name is "Decal".
>I have 5,000 records (therefore 5,000 Decal numbers)
>There are 4,000 *.jpg pictures.
>3,000 Decal have pictures which means 1,000 (or less) of those 3,000 Decal have duplicated pictures.
>
>WITHOUT storing image in the database or table (as Object or General, whatever), how to link the Decal to DOS file (*.jpg) as well how to display the picture by a click of a button (on a form)? Displaying one picture would be easy, but if there is multiple picture for one Decal record?
>
>Example (just an example!): One record, Decal is "PC2233" and there are 4 pictures for "PC2233", via, CPU, monitor, keyboard, and mouse. How would I display the pictures as well how to have a pop up list or something since there are more than 1 picture for the user to pick to display rather showing four new windows of picture of each item?
>
>Comon, can you follow this?
>
>Chuck

Joseph C. Kempel
Systems Analyst/Programmer
JNC