Vendors to Products, at the end, you mentioned that in our "Products to Vendors" that you could update prices in the Products subform on the VendorsF. I was just curious how that would prevent changing any old records showing what we paid for an item in the past...say last year it was 10.00 and now it is 10.50. How would the UnitCost being in the JunctionT prevent those records from being changed in retrospect.
Pamela, you are absolutely, 100% correct. If you make that change it changes everywhere in your database. At this point, you'll just have to create a new product with different pricing. It's a more advanced feature, but in Access Expert 22 I teach you how to get around this by copying the price (and other product info) into your related records.
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 7.
