authomatically transfer data between tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables - completed training by date and proposed training by date
- is there any way that once the data in the proposed training table has
passed todays date, it can automatically be transfered to the completed
training table?
 
It sounds like your database design my need to be revisited. In just
taking a cursory glance, I would probably add a field to one of the
tables (txtStatus) which designates if the training is PROPOSED or
COMPLETED move all of the data into that table and delete the other.
 
Back
Top