Hello folks,
This may not be possible. But I really hope it is. If it is, then I will need instructions on how to do it. I am not very good at code.
Database1 is named DPR-Main. It has a table called tblBuilds. Also in the DB are alot of forms for reading this table in different views. When a project (record) is complete, a date is placed in the completed field.
Database2 is named DPR-Completed-2013. In this I have a table called tblBuilds_Completed_2013.
This is what I would like to happen....
When the date is entered in the completed field of tblbuilds of database1, I want that record to be copied over to the table tblBuilds_Completed_2013 in database2. And if it is possible, the original record in tblbuilds should be deleted. The reason for this to keep the database sizes reasonable.
I am however concerned about 1 thing is this indeed possible. Would the original records ID also be copied over?