Move records between table with button

[Hassan Merzha]

I have been asked at my job to come up with an answer to this question:

we have a database that I designed that keeps track of basic inventory
items, the db contains 5 tables for 5 different inventories but all of the
tables contain the same columns.

when an record is inputted into a certain table, is there a way to create a
button on the form that will MOVE that specific record from any one of those
tables and ADD it to a 6th table (the 6th table will already be created, but
we want the item in question to moved when it's no longer needed in the
inventory)

I hope I've explained this well enough, I've tried working with the queries
and macros but I've not come up with a viable solution yet. I'm not
anywhere close to being very knowledgable about access but I can follow a
step-by-step direction very well.

any help is greatly appreciated.

 

[Allen Browne]

You can move the item by executing an Append query to add it to the other
table, and then a Delete query to remove it from the first.

To ensure the Delete does not occur without the append, see this article:
Archive: Move records to another table
at:
http://allenbrowne.com/ser-37.html

You could make your job *much* easier by combining all these tables into
one, with an extra field to identify whatever the difference was.