I think this should be simple...but....
I have a table called "BOOKS" that lists all the books I stock. The "BOOK_INVENTORY" field contains the number of copies I have in stock (e.g. 10 copies).
I have a query called "BOOK ORDERS" that lists the Order No., Order Line No., the book ordered and the quantity ordered.
This query has a calculated field:
NEW_BOOK_INVENTORY:"QUANTITY-BOOK_INVENTORY"
How do I update the "BOOK_INVENTORY" field on the "BOOKS" table with the number in the "NEW_BOOK_INVENTORY" field on the query?
PS - I am not using forms at this point for users to enter their orders - only tables.
Thanks in advance,
Jamiek555
I have a table called "BOOKS" that lists all the books I stock. The "BOOK_INVENTORY" field contains the number of copies I have in stock (e.g. 10 copies).
I have a query called "BOOK ORDERS" that lists the Order No., Order Line No., the book ordered and the quantity ordered.
This query has a calculated field:
NEW_BOOK_INVENTORY:"QUANTITY-BOOK_INVENTORY"
How do I update the "BOOK_INVENTORY" field on the "BOOKS" table with the number in the "NEW_BOOK_INVENTORY" field on the query?
PS - I am not using forms at this point for users to enter their orders - only tables.
Thanks in advance,
Jamiek555