authomatically transfer data between tables

M

MissV

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?
 
D

David C. Holley

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.
 
Top