I am wondering if this is possible.
I would like to have a button next to a field on my form which when pressed will copy the contents of the field to a different field on the same form/record and set the originating field back to null.
I would also like the field being copied in to to not have any previous data erased and overwritten. I'd just like the data to be added to whats already there.
I am designing a Miss Utility ticket tracking database which needs to be updated frequently, each job gets assigned a new ticket number every time it's updated and I want to store all of the old ticket numbers in a memo field just for reference and safekeeping.
Can something like this be done? TIA.