1 Reply Latest reply on Jul 14, 2009 8:56 AM by TSGal

    Complex Pricing Structure

    kliegl12

      Title

      Complex Pricing Structure

      Post

      I copied my original post, It was a response to a solved string (RE: Complex Pricing Structure) and I was afraid no one would see it...

       

       

      Greetings, I have been playing along with this because I have such a similar structure as Kat4 does, I am a spreadsheet guy writing a database for the first time... So I have the freedom to set this up anyway I want...  but the lack of knowledge to do it right.

       

      The question that I am struggling with is how to write a case calculation to choose the right price. 

       

      I have 2 "customer types" (Vendor and Customer) and two location types "State" (in state and out of state lets say Az) so I have 4 prices to choose from with each of my products. 

      1. Vendor, Az or Vendor, not Az

      2. Customer, Az or Customer, not Az

      A vendor will never get a customer price and a customer can't get the vendor price. 

       

      I have a product page set up with each of the prices on it. I Have a portal window, on my invoices page (thats where the orders are done) and it works with a single price lookup off of the product ID on the Products page, (and I have a line Items TO inserted between, for the many to many),  so I know the relationships are good.  

       

      I want to put in a case calculation, but should it be a series of GET calculations or a series of IF calculations?

       

      Thanks in advance...