How to retrieve the right price from product table?
This is my first post. I am currently building an database to manage inventory. I have a a customer table and one of the field is customer category : retail or wholesale.
In my product table, I have a retail selling price and a wholesale selling price.
I am now creating a customer order. It is pulling data from both the customer and products tables. How can I get the right selling price based on the customer category (retail or wholesale)?
I would like to use a lookup function so that if my prices change later on, my prior customer orders data won't change.
Thanks for your help