good morning, please help. (new to a2k)
i have a Products Table with fields ProductName and Price.
another Table named ClientAccount have fields Product and Quantity etc.
i have Mainform to capture other info and then a Subform "client account".
so in the subform the user selects a ProductName (from combo) and the select query (on which the sub-form is based) then gives the Product Price. No problem; the user enters the Quantity, access calculates the Total and so on)
the PROBLEM: on 1 October the Product Price will Increase.
I have tested my db but when i CHANGE THE PRICE in the PRODUCTS TABLE it also changes/updates the CURRENT/PREVIOUS client accounts, ie: the client's account from say January is now calculated against the NEW PRICE.
what must i do ??
thanks,
Piet.
i have a Products Table with fields ProductName and Price.
another Table named ClientAccount have fields Product and Quantity etc.
i have Mainform to capture other info and then a Subform "client account".
so in the subform the user selects a ProductName (from combo) and the select query (on which the sub-form is based) then gives the Product Price. No problem; the user enters the Quantity, access calculates the Total and so on)
the PROBLEM: on 1 October the Product Price will Increase.
I have tested my db but when i CHANGE THE PRICE in the PRODUCTS TABLE it also changes/updates the CURRENT/PREVIOUS client accounts, ie: the client's account from say January is now calculated against the NEW PRICE.
what must i do ??
thanks,
Piet.
