update

C

charlotte

i have two tables:
Book details containing Book ISBN, Title, Author, Price, and Quantity in Stock

i also have another table received orders containing Order ID Book ISBN
Quantity and Date ordered.

both these tables have forms. im trying to create an update command that
will update the 'quantity in stock' field when a new record is created in the
received orders.
so basically i want the stock level to update when a delivery arrives.

any help would be appreciated
charlotte
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Want stock to update in stock table when order is made in order ta 1
Add contents of two cells when a tick box is ticked 2
Update Query 1
inventory problem 1
LIST QUERY PROBLEM 0
Using an update query to update amount in stock automatically 1
Complex Append Query 1
Update Query Error 2

Top