Simply link the table (Get External Data – Link) from the history database into your current database. Say the table in current is Work and you would link WorkHistory from the history database. Now both databases are in you main application database. Then as the work is compelete, you could make an append query to append the records from the Work table to the WorkHistory table and then a delete query to delete the records from the Work table. You could make a union query called AllWork like this: Select * from Work Union Select * from WorkHistory. Now when you access that query for example in a report or look up form, you will have all records – both current and history.