Inserting multiple values into a record in access and displaying those values....

[Calmaris]

Ok what I would like to do is insert multiple values in a record in access that will look like this name,name,name,name.... those names will obviously be different but I need to append the record without loosing the existing data but adding the new value. Also how can I display those values individually in the record to the page? Do I need to make an array? I just don't want a huge database filled with records for each individual name.

[CardboardHammer]

Store the content of the field of the record in a string.
Update the record with the string with the new data appended.

You could parse the string or you could store the formatting with the data in the record, such that you just spew the whole thing out in one shot.

Note that doing things the way you're doing is somewhat (probably highly) questionable... You probably won't save much on bloat by packing data like that instead of storing one datum per record and you certainly won't be saving yourself any hassle.

[Calmaris]

Perhaps your right...I just don't want a jug @#$ of a database. I suppose I could get the user to delete that record when they are finished with it. Thx for the suggestion you just gave me a new idea.

[CardboardHammer]

Glad to help... what exactly is the bigger picture of what you're doing? Perhaps I could be of a bit more help...

[PeOfEo]

does it have to be one record, what is the point of using one?