Append to an existing record

[Stoss]

Hi,

I was wondering if it was possible to append to an existing record. I have a table that has a memo field. I would like to pull a record and append new information into that memo field and keeping the data that was already there.

==edited== Sorry, I should have said that this will be updated remotely and automatically.

Thanks,
Stoss

 

[Mr. B]

Try assigning the current value in the memo field to a string type variable, append or concatenate the new string value to the variable and then update the memo field with the value that is now in the variable.

 

[Stoss]

Thanks much!

I was thinking that that was the road I had to take with this one.

-Stoss