This is Aruna .I am working on Access database. I got a problem, Once we delete one record from one table, Automatically insert that record into another table.
Is it possible? Please can u suggest Sir.
by 
Kethireddy
ANSWERS: 1
-
Rather than delete the record you need to use an Append query. Elect to make a new query in Design View, select the table you want to remove the record from. Then go to the Query Type toolbar button and select Append Query and select the table you want the record to be inserted into.
RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC