simple archive techniques ??

[Steven Cappiello]

Hi,

I have a database that is used to track job applicants. Each season, we have a "recruitment" period, twice per year. After each season, I'd like to be able to archive those applicants who we're no longer interested in... however, we'd like to be able to pull up their records at a moment's notice.

I was thinking that I could add a "season" field.. and then script the navigation and find and "new record" buttons to all stay within the realm of the current season "Fall '04" for example.

does that make sense or is there an easier way ? should I perhaps just have an "archive" database that you send records to when they no longer need to be in the "current" database :

and then switch to the archive for the infrequent amount of times we need to see one of the older records ??

the archive won't get much use... i also don't have great programming/scripting abilities, so the simplest most straightforward way of doing this would probably be best.

thanks