>I have an application where I want to integrate multiple text files and images to a single record. For example the employee record. Does the general field allow me to append multiple files in one field or i have to create a set of records. Does anyone have any idea how i can do this .... Any suggestions are very much appreciated.
>
>Thanks
What do you mean, "integrate ... to a single record". What is the end-effect you want to achieve?
For purposes of normalization, I would normally put each image / text file in a separate record. For instance, if you have a table PERSON, and want several pictures / descriptions for every person, create a separate table PICTURE, which would have several records for each person.
Also, don't put pictures into general fields. The general field takes up 20 times as much space as a JPG file. Just keep the JPG-file, and keep the filename in the table.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
