Search multiple database files
We have a database that tracks all jobs of one client. This year, we changed the calculation of one of the calculation fields. Therefore, we created a new database beginning with the year 2009. The 2009 database is exactly the same as the first database with the exception of the one calculation.
While in the 2009 database, can we execute a search of all records in the 2009 database and the database with the previous years' records so that the search results might include records from both databases? If so, how is this done?