Recent content by workwork

Thank you for your help! I've managed the first but I'm still struggling with the second. So I've used tblBook and have brought down the BookID, Title, Author, Quantity, ReorderLevel, ReorderQuantity. I basically want it so that when the Quantity is below the ReorderLevel, the Title, Author...

I'd like to create a query where when a book is ordered, the book quantity in a different table is updated and subtracts the quantity ordered. I'd also like another query where, when a books quantity falls below 5, the book title, with the reorder level is sent to either a new table called...