AnsweredAssumed Answered

How to retrieve the right price from product table?

Question asked by MarieGuyon on May 21, 2014
Latest reply on May 21, 2014 by philmodjunk

Title

How to retrieve the right price from product table?

Post

     Hi there,

     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
     Lili

Outcomes