Remove a data Line

[Guest]

I need to remove a record based on user input.

User Input [Part #] => Remove from "Inventory" table and add to "New
Inventory" table.

I ued an append query to add the record to a new table but when I try to
delete matching records from original table, I get an error "Could Not Delete
from Specified Table".

What is my best option.

Thanks

 

[Guest]

NEVER MIND!


I added a new Y/N field to the original table called "Remove", created an
update query to change to yes and then another query to delete if Remove is
"yes"

DUH!!!!!