Rather than move the members to another table, why not use a yes/no field (checkbox control on the form) to indicate either "current" - where checked would equal "not expired" or "expired", which would mean that the membership was not up-to-date? Then you can track that information all in a single table.
HTH! Richard --- In [email protected], "Hassan" <[EMAIL PROTECTED]> wrote: > Hi All, > I have this membership access database that i am working with and i am > having some problems that i need your help with. > > First let me explain my database to you guys, this is a membership > database and membership is an year long only. > > What I would like to do is to move the expired members to an another > table. Since membership is year long only after each year i want the > memebers to move to another table if they dont want to continue the > membership and in the future if they want to renew it i can just simply > move them back to the main table. > > is that possible?? > > Any help would be nice. > thanks alot > > here is my database http://www.megaupload.com/?d=40CLA7QM its 89kb. ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
