I'm creating an HR database and I'm trying to find a way to move information from one table to another within the database. Basically, when a candidate gets hired, I want to move all the candidate's information to the trainees table. I'd like to be able to do this by just clicking a button on the candidate form. Help!
