We added that as a feature of an accounting system, to store tiffs of scanned checks with the invoice record that they paid.

If you want to get really fancy our system tied the tiffs together with the invoice record using another table, since there could be multiple tiffs for one invoice.

Then we used a 3rd party activex for displaying tiffs. So when you clicked on the button on the invoice to view available scans of checks, a form displayed that had the scan displayed as well as many options for viewing the graphic thanks to the library.

Here's the control we used:

http://www.viscomsoft.com/products/imageviewercp/



>I'm sure that this must have been covered before. I'm looking for info on the best approaches in storing and retrieving a couple of thousand JPG picture files that match with items (one to one) in my system, for display both in Forms and in reports. The JPG files can be named to match the item keys.
>
>My first thought is to put them all in a Pictures folder, then to fill in the picture property of my form's image control with the full path name of the appropriate JPG file. At this is my first time working with JPG's, I thought it would be wise to ask for a few thoughts at this point.
>
>Bob