Move a record to another table after due date (1 Viewer)

A

Adriana266

New member

Local time

Today, 17:41

Joined

May 24, 2017

Messages

1

• May 24, 2017

• #1

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

 

T

Tieval

Still Clueless

Local time

Today, 10:41

Joined

Jun 26, 2015

Messages

475

• May 24, 2017

• #2

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.

 

P

plog

Banishment Pending

Local time

Today, 04:41

Joined

May 11, 2011

Messages

11,638

• May 24, 2017

• #3

I wanted to move a record to another table

Click to expand...

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.