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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Update query question 1
Park and Ride in to Central London? 2
Programming Help Please 1
Add record from each entry in table for each user in another table 1
Basic Relationship Question 3
Sum Trouble 1
Parsing (Contencate?) 2 fields into 1 10

Back
Top