My question relates to a Membership Form that holds the current years membership ...Their Number, Name, Adddress etc

For reasons the Club only knows they give each member a new number each new year so that numbers all run simply from 1 to say 250 with no gaps.

I have the last 5 years Membership data in a separate Table called tblPastMembers. members come and go and come back again so we have 500 Names etc and average 250 per year.

I am looking for a method that allows me (The Memberhip Form for current year and PastMembers Form are both based on one Table each tblMembership for curent year and tblPastMembers for history) to transfer easily from tblPastMembers to tblMembership via the Membership Form.

I was hoping to be able to see a Past Member details on the form and then transfer to the Current year, simply adding the new Membership Number when I get in into the Current years form.

I remove any past Membership Numbers when storing daya in the tblPastMembers.

I have seen a method that transfers data between two single forms BUT my problem is how to achieve this as I will be adding to the current years Membership Form that will alraedy have records , so this transfer could be into record say 65, which is the next available number.

Alternatively maybe a COPY and PASTE method when Member found in PastMembers Form but no idea if that is possible.

Any help or alternative method would be appreciated.

Alexander

This post has been edited by Alexander: Oct 16 2010, 04:03 AM

Hello,
You may want to change so that each member is uniquely identified by a permanent number which is fixed.

However if that is not possible then make members primary key consisted of concatenation of the year plus member number so that each member for each year can be uniquely identified.

oemar00.

Many thanks oemar00

That makes sense. I tried to get them to accept a Membership Number is for life but "old habits die hard".

Your suggestion is a solution and one I am considering.

Many thanks

Alexander