cloning records

Hi, is there a way to somehow clone records together ?? For example: I have
a table that has Mbr A with different events that happen - I would like to be
able to pull all of them in together and update other fields based on their
prior data

For example:
MemberA has insurance 1/1/2008 - a new policy

Data would look like:

Member EffDt EndDt Event Amt Renewed Amt
Delta
A 1/1/2008 12/31/2008 New $500 $1000
$500
A 1/2/2009 12/31/2009 Ren $1000 $2000
$1000
A 1/1/2010 12/31/9999 Ren 2 $2000

The Renewed Amt & the Delta amount can only be populated as the new policies
come thru?

Any ideas how to do this or go about it another way?

Thank you
--
Thank you in advance!!!!