D
daisy
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
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