Arg81
Well-known member
Hi Guys,
I assume when moving a record from one table to another, I need to create a stored procedure than first calls an insert, and then delete?
I.E. I'm working on a computer audit. A PC has just been scrapped. I want to move it from the Main Audit table to the scrapped table (columns are the same).
In Access, I did this in the form off a macro running two queries, first an append, and then a delete (to remove it from the main table).
I have 3 tables that it could possibly move to - Scrap, Stolen or Sold. I need to create a procedure that can move any selected record to either one of those tables.
Any help much appriciated.
cheers,
Luke
I assume when moving a record from one table to another, I need to create a stored procedure than first calls an insert, and then delete?
I.E. I'm working on a computer audit. A PC has just been scrapped. I want to move it from the Main Audit table to the scrapped table (columns are the same).
In Access, I did this in the form off a macro running two queries, first an append, and then a delete (to remove it from the main table).
I have 3 tables that it could possibly move to - Scrap, Stolen or Sold. I need to create a procedure that can move any selected record to either one of those tables.
Any help much appriciated.
cheers,
Luke