>I am working on an app where the user will select pictures of products and match them with products in another table. Many products could use a single picture and a product might use several different pictures. (I do know how to handle that part.)
>
>To make it easy for the user I would like to show all the pictures (thumbnail size which I already have) in a grid (could be over a thousand) along with a description the user entered when the picture was saved. I tried saving a picture (small .bmp) to a general field but I can't seem to be able to do anything with the general field. If I browse the table and open the field the picture shows but I can't seem to figure out how to refer to the general field in an image on a form or in a column in a grid. I have never done this before so I'm kinda lost right now.
The only way (that I know of) to show the images in the grid is to have one imageobject per image in the column which shows the images, and set the dynamiccurrentcontrol to somehow correspond to the image you want to show. It was bad enough to try to do this for just six images - and is definitely not worth using as an approach to all images.
You may restrict it to only visible rows, so whenever the grid scrolls, in a refresh, assign .picture={filename for current record} to one image object at a time. Now this requires dancing with the grid while it refreshes, which is not for the faint of heart.
An easier approach may be to use some ActiveX instead of the grid to host the images, although most of the image capable ActiveXes I saw require image list object, which means pre-loading the images. A bit less easy but more flexible would be to generate a dynamic webpage and have the app change its HTML on the fly, as you add images.
Whichever way you go, I can only promise it will be interesting ;).