markswan20
Technical User
Hi everyone.
I have created a form that pulls data from column 1 in a combo box and places it in a different text box. The information is used as the price of the product.
The information is taken from a second table called ProductID, my problem is when I need to change my prices within the ProductID table they automatically change for my existing customers. Is there a way of making the information automatically or on the click of a button transfer to my main database so that when i do change my prices it won't affect my older customers.
Thank you for you time
Mark
I have created a form that pulls data from column 1 in a combo box and places it in a different text box. The information is used as the price of the product.
The information is taken from a second table called ProductID, my problem is when I need to change my prices within the ProductID table they automatically change for my existing customers. Is there a way of making the information automatically or on the click of a button transfer to my main database so that when i do change my prices it won't affect my older customers.
Thank you for you time
Mark