Moving a row of data from one table to another

[mhw]

Hello.

I have a simple database setup for my own use. It's local and will remain that way so no need to hook it up with a server etc..

It's the most basic of applications, to help me keep track of my web design jobs.

Tables

• Customers
• Pending Jobs
• Current Jobs
• Completed Jobs

Say I enter all of the information for a new job into the Pending Jobs table. Once I start the job how difficult would it be for me to move the entire row of data from Pending Jobs to Current Jobs, whilst keeping all of the data the same.

I would imagine it used some vB code activated by a button in a form?

All help appreciated.

 

[Dennisk]

create an append query to copy the data

 

[DCrake]

Why not have just one table and have a status indicator field denoting Pending, current, completed, etc. Then when a job changes from pending to current you simply update the status field

David