move a row from one table to another in the same database

[fuzzywig]

Hi,

Not sure if this is possible, but here goes.

I am creating a repairs database, what I want to do is create two separate tables one called open jobs and the second called closed jobs, when I have completed the repair I want to click a button that will move the completed job to the closed table. This button will be placed on the form for the open job.



Thanks for any help.

[JoeM]

You could do this using an Append Query to copy the data from one table to the next, and then use a subsequent Delete Query to remove it from the original.

However, I would caution you against trying to move records from one table to the other. If the jib gets interrupted or there is some kind of error where one of the two action queries does not work properly, it could destroy the integrity of your database. It seems to me that a better approach would just be to add a "Closed" Yes/No field to your table, and just update that field when you want to close the record. No need for two tables then, and no need to move data.