moving fields to different tables

[Russ]

Here is my problem:
When I am with a new client I want to enter there order in
my field named "order." but the next time I am with the
client I want the value that I entered in "order" to
appear in a seperate table in a field
called "previousorder" Is this possible and how would I
go about doing this?

Thanks