order level update

hi i have attached a copy of the tables i am trying to update and was wondering does anyone have any ideas on how to update an order level.
How i want the database to work is that i will be ordering 200 items and then in three months i will recive 100 items each month.

i was wondering if there is any way that i can update the total delivered each month. so if i inputted in 100 for one month and another 100 fro the second month the database will show me that only 200 have been delivered so far

thank you

kabir hussein

I have two suggests for you.

Without understanding all the logic behind you database structure... I would eliminate the table with the OrderQuanityID (Key). It isn't needed. And normalize you database structure. You are storing information that in multiple locations, that doesn't need to be there (IE PartID in the OrderHistory Table, You know the partID already because on the relationship between Order and Order History)


With that said
All you need to do is create a query, that is creates the information you need on the fly, that is GROUPED based on PurchaseOrderID, OrderLineID (or PartID), and SUM Qty received. This will tell you for this PO, this OrderLine(PartID) you have received this much.