Software

Ask something
Question Locked

Move record from one table to another

0 helpful
4 replies

by acracker

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Hi, I am making a database that involves three different tables, I'll call them PRIMARY, RETURNED and MISSING. Right now I have it set up so that a combo box will search the PRIMARY table based upon last name and then show the ID, lastname, and firstname of the person on the form. I need to make a couple of buttons or something that will take the entire record from the PRIMARY table and move it to the RETURNED or MISSING table depending on which button is pressed. I want the data to be moved, not copied so that it will no longer exist in the PRIMARY table, only in the MISSING or RETURNED table that it got moved to. I just started working with MS Access and I don't know any VBA, so please excuse my ignorance. Thanks for any help you can give me.

4 replies

by tony hopkinson

Insert into returned
select * from [Primary] Where ID = ?

Not a good idea to use key words (PRIMARY) as your entity names.

by acracker

I'm sorry, but I'm not sure I follow you. Where do I go to perform this action and how do I do it? Thanks.

by tony hopkinson

I'ma bit rusty on access, but if you had a returned button, you could make the action to run a query and supply the id parameter on the form.

I'm sure there's a way to put this query in the designer (append query ?), but I always found it easier to use the sql view on the query page and type the raw SQl in.

This discussion is closed to new replies.