I am managing a database and need to know if there is away of moving 'completed' records into another database but keep them linked.
Senario is: We have records of pieces of work coming into the office and which take about amonth to complete the cycle.
My query is instead of having this database then filling up with completed and uncompleted records, how would you move the completed lines into a second databse, yet have it linked?
I would think i would need part of it that states eg 'Record Complete' where would input a 'Y' to signify this. Then what would i need to do to move that line into a second database for completed records?
Any suggestions or solutions from others that have similar projects much appreciated.