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?