Hello Doug,

Yep, you get major bloat using general fields. Storing the file name is the way to go. See FAQ #7862 for details on how to print them in a report; if you have any further questions feel free to ask.

The caution (#4) is important. I create a cursor before I print the report, and the cursor contains a the file name of a blank JPG for records where there is no associated picture.

HTH,

-steve

>I'm trying to create a personnel directory with photos and am doing this by using a GENERAL field. The problem is that the table's .FPT file is huge! How can I reduce it?
>
>The VFP Help says the following about the GENERAL field type:
>
> "If you link an OLE object, your table contains only the reference to the data and to the application that created it. If you embed an OLE object, the table contains a copy of the data as well as a reference to the application that created it."
>
>How do I embed a link to a JPG photo in a GENERAL field so that I'm only storing a link and then can print the photos in my report? Will that save the disk space and still allow the report to print the photos?
>
>Doug Symes
>IT Technician
>InterConnect Wiring,LP