Bill, you are correct. You do NOT want the sales tax changing on all OLD records. When we get to the order entry system in Access 301/302 I'll show you an exception - when you want to save historical data. For example, when you add a PRODUCT to an invoice. If the product price changes, you don't want it updating all of your old invoices. It's the exact same scenario. We'll save the product price in the invoice table to keep it at the time of the sale.
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
Microsoft Excel 201.