How to go about using 2 different pricelists
Im making a db for the company i work for and its my first time working with access, i also have very little knowledge of vba.
On the order form i have atm, there is a subform where my bosses would be selecting the products they want for the particular order where the data is retrieved from a price list that doesnt change. However we do get contracts where these prices will vary, so what i thought of is adding a check box which would bring up a new subform and has the same fields and all they would need to do is add the varied products and their prices. Am i thinking about doing this the right way or is there an easier way?
The reason i mention this is because, if i modify the price in the subform where the standard pricelist is the price seems to change for all the orders not just for that one specific order..
what are your thoughts?