Move a record to another table after due date

[Adriana266]

Hi,

I wanted to move a record to another table automatically after the due date

Example:

The due date is on 31/05/2017 , after the date , the record will move to another table

Thanks

 

[Tieval]

Logically you could do this with an update query and copy the records to a second table and delete them from the first. Set the query to run when the database loads.

However, you shouldn't need to do this, keep it all in the same table and query your data for before and after the current date as required.

 

[plog]

I wanted to move a record to another table

That's not how databases work. You don't create tables to seperate data when you can logically do it. Instead, you would create a query to determine which records have past their due date and run that query when you want to use that data.