M
Melissa
Help! I've created a purchase order database that captures our customers'
purchase order requests. Based on the tables and relationships I've set up
in this database, all a user has to do is enter the Item Number and the
Quantity of the item(s) the customer has requested. Then a Purchase Orders
report is generated that shows the Item Number, the Item Description, the
item's Price, and the Quantity (among other things). Everything works great;
however, when the price of an item changes, it changes the price for past
Purchase Orders as well, which messes up any historical data I might want to
capture. I understand why it does this, I just didn't know if there was
another way of going about changing the prices so that I can keep historical
information accurate. If anybody has any ideas, that would be great. I
really appreciate the help!
purchase order requests. Based on the tables and relationships I've set up
in this database, all a user has to do is enter the Item Number and the
Quantity of the item(s) the customer has requested. Then a Purchase Orders
report is generated that shows the Item Number, the Item Description, the
item's Price, and the Quantity (among other things). Everything works great;
however, when the price of an item changes, it changes the price for past
Purchase Orders as well, which messes up any historical data I might want to
capture. I understand why it does this, I just didn't know if there was
another way of going about changing the prices so that I can keep historical
information accurate. If anybody has any ideas, that would be great. I
really appreciate the help!