Copy records for registration renewal

Copy records for registration renewal

I am building a membership database and could use some help. I have a form for members, a form for membership packages and a form for membership registrations. This third form, call it REGISTRATION, has a lookup field from MEMBERS and lookup field from PACKAGES then it has a start date and an end date.

At the end of the year, I want to renew people's memberships. I need to keep the expired registration for historical purposes and then start a new membership.

Can anyone think of way to copy the old registration to new records with updated start and end dates?

I really need to sort this out.

Cheers!