So far in this thread, I haven't seen anybody answer what I consider to
be a very important question about the original poster's requirements:
Why are you updating the history table????
If you update the history table, you lose old history. Instead, I think
you should be adding a new record to the history table for every
alteration made to the old one. The history table would have to contain
a field for the type of change that was made (insert, update or delete).
RobR