Hi Everyone
I was wondering if anyone has any great ideas on archiving.
I have a database, lets say a sales database. Future transactions are
really important, but past transactions are only important from time to
time.
Therefore, I would like to archive them so that they are not visible during
normal processing, just as and when required (e.g. statistics, the
occasional inquiry).
This I how I thought it would work:
1. I duplicate the table of sales.
2. I identify old sales
3. I copy them into the duplicated table
4. I delete them from the table that was duplicated.
Sound simple, but I already foresee a host of problems:
1. I delete the contact who I sold the goods to, now it does not link any
longer to the archived sales record
2. I always need just that one record that was archived
3. etc....
Ideally, what I would like to do is to keep the records in the same table,
but somehow hide them.
Now I know that you might say that I should use a query. But that would get
very confusing very quickly.
I can also tell you that the sales table is a linked table, could I perhaps
put some sort of selection statement in the link syntax????
As you can see, I am unsure on how to proceed. Is there anyone out there
with any good ideas????