Forcing records together?

[newbieaccess]

Hi, is there a way to somehow clone records together ?? I'm not sure I'm using the correct terminology. I'm new to this. 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 dataFor example:MemberA has insurance 1/1/2008 - a new policyData would look like:Member EffDt EndDt Event Amt Renewed Amt DeltaA 1/1/2008 12/31/2008 New $500 $1000 $500A 1/2/2009 12/31/2009 Ren $1000 $2000 $1000A 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--

 

[dkinley]

Not sure. I am a bit confused on what you are trying to do so perhaps posting a graphic of a before/after with everything all organized and maybe some dotted lines to help us see what you are trying to do will get a more defined response.

Can do it in Paint or something as long as it is in a common format such as a .jpg should work.

-dK