Getting Data from one table to another

[John Corbin]

I have a table which I want to contain the most currrent data on my users. I
have a history table which I would like to move the current data to when
there is a change so that I have an audit trail/history of changes to each
user. So how do i get the data in the users table to the histroy table when
I need to update the users table. Both tables have the same data items.


John
jcorbin@stripped