How to make archive system?

[eneyardi]

How to make archive system?

[dsatino]

1. You need to be much more specific.
2. You're essentially asking how to build a DB from scratch so this is really about a million questions in one.

If you have MS Access, then you have at least a sufficient tool for this. Now you need to do some reading on relational databases. Understand tables structures, keys, etc.

[eneyardi]

thnks.,
I have a two tables name tblDTS and archtbl
my field names are subject and status
i have a form name list, datasource is tblDTS, my field names for this form are also subject and status.
in typing a word in status field, you have an option to type only done or pending. now this is my question, how can automatically the record will move to other table when i type done in status field?

[dsatino]

If all you're doing is moving the same exact data from one table to another, with the only exception being that one table has the status=pending data and the other has the status=done data then you don't even need the archtbl.

Keep everything in the one table and just use the 'status' field show/supress data from forms, reports, queries, etc.

[eneyardi]

thnx alot.. it helps..