>Maybe I need to clarify what I'm trying to do with this database having a general field in it.
>Our system has a Customer Masterfile Maintenance routine. Each of the customers has
>a picture associated with his record (a bmp file), as well as several scanned document files.
>There is a command button on the customer screen that when selected displays a grid
>of these associated files. When you double click the grid selection you want it, should display
>the associated file whether it be a bmp picture, a pdf document, or an Excel Spreadsheet..
>
>If there is a better way than using a general field to link to each of these documents I would
>appreciate anyone telling me how.
>
>Thanks for all of your responses to my previous post.
>
>Brad

You can view information in general fields (if the creating program is installed), but you can't get information back out again. Also, the information in a general field may use up a LOT of space - for example, a 50 KB JPG file might use up over 1 MB of space in the memo file.

One option is to store the images, PDF files, etc. in separate files under Windows, and only store the filename in the table. This basically solves the 2 GB file limit in Visual FoxPro.