Data from one table to other.

You could probably create a database trigger to copy the data.

What database are you using?

Good day.
It's been a while, electricity and internet is a bit difficult here due to a super typhoon struck us.
Anyway, I think it is better for you to give a detailed process/procedure you are trying to achieve. It is easier that way. If you can create a simple program to show it then specify to what process you are stuck with. It is much better for someone to give you an idea. As to trigger asawyer was talking about. It is an advance feature of sql (sqlite in your case i think). You can google it (how to create trigger on sqlite) for you will have to do it manually(sql query). You can use database viewer software to do it too(e.g. navicat-paid). There's another option like having a hidden component to hold the Date you are trying to save in another table. but as I have said, it is easier if you can narrow it down by citing a detailed explanation.