In Microsoft Access you can run an Append Data Query, to move (append) records from one table to another table. How do I do this in Base? Here is my example -
I have a large database of stock for sale and sold, all unique items. I want to automate the archiving of the sold items from the In Stock table to a table called Sold. I have created a list box field in For Sale called “Select” containing the options of “In Stock” “Sold” and “Pending”. With Access, it was possible to create an Append Table Query that would automatically add any item selected as “Sold” to the Sold table, and I could also run a Delete Query to delete items flagged as “Sold” from the For Sale table. Is there any way of doing this using a query in Base?