you mentioned in the lesson that an update query is usefulto add 5% to active products. my question is since there are orders which were orderedwhen the price wasn'tadded to 5% will they also be updated? if the answer is yes, this might mess up all passedorders with a wrong price
Very good observation. Yes, that is true. This is one of the problems with building a "teaching" database. Right now, as you figured out, your orders are directly related to your products. So if you make a change to one of the product's details (like name or price) then all of your orders are effected. Later on, in Access Expert 22, I show you how to fix this by copying product details to the order detail table as you create the order. It requires VBA or a macro, which is why I cover it later. There's nothing wrong with the current method, except you cannot make changes to products once they're used on orders.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 13.
