AnsweredAssumed Answered

Archiving Records

Question asked by TuxfordC on Jul 21, 2012
Latest reply on Jul 21, 2012 by TuxfordC


Archiving Records


 Is the following proposal a sensible/logical way for archiving income/tax records?

 The income data needs to be kept for a minimum of ten years, and preferably kept small.  I'm thinking about having a separate table for each

financial year, identical structures with no more than six fields, Tables identified by including Year date in the name. Data recording change to the

next table to be controlled automatically by the date.  Completed tables to be exported for archive and deleted from the programme.  

Okay, or is the idea stupid?